Create a SQL request
Table A has a unique identifier, table B has records containing a column with the same identifier and a column with the sum. The essence of the task is to write a JOIN query that would take identifier from the column A and by it from the column B counted SUM and TOTAL and grouped by these idealizers.
It is at the exit to get a grouped mass from column B by idealizers and the total amount by this id.
Dump tables can be downloaded to the face on request.
Client's review of cooperation with Yevgeny Kirkilevsky
Create a SQL requestThank you Eugene for the work, quickly disappointed and resolved the question. I recommend cooperation
Freelancer's review of cooperation with Dmitry F.
Create a SQL requestA good faithful customer. I described the task grammatically, although I had a furniture, I waited and quickly checked the job and paid for the order. I advise you to respond to your projects.
-
354 2 0 Send a Dump to the Face.
........................................................
-
245 4 0 Good day . Ready to fulfill your order! Contact us, I will be happy to collaborate!
-
2102 226 0 1 Hello to you. I will help with the request. Remove the Dump Base in the Face.
-
2657 427 9 1 Готов сделать
=- = -= - =- =- =- =- = -= -= -= -= -= - =- =- =- = -= -= -= -= -= - =- =- =- = -= -= -= - =- =- = -= -=-
-
426 16 0 Hello to you! A simple task. Please send the Dump, I will send the work outcome. I do in urgent order!
-
385 14 1 Good Morning . I will perform in 5 minutes of work. The experience of sql o o o o o o o o o o
-
В таблице A есть уникальный идентификатор, в таблице B есть записи в которых содержится столбец с таким же идентификатором и еще столбец с суммой. Суть задачи написать JOIN запрос, который бы брал из столбца А идентификаторы и по ним из столбца B считал SUM и TOTAL и сгрупировал бы по этим идетификаторам.
Тоесть на выходе надо получить сгрупированный массив из столбца B по идетификаторам и общей суммой по этим id
select
b.id,
sum(b.FIELD_SUM) s
from TABLE_A a
join TABLE_B b
on a.id = b.id
group by b.id
Не совсем понял, что такое TOTAL.
Пришлите на [email protected] схему таблиц или дамп доделаю запрос, если сами не подставите названия таблиц.
Нет тут за что денег брать 🙂 -
Current freelance projects in the category Databases & SQL
Vibe coding through Claude Code
350 USD
Develop a closed web platform for corporate events with personal invitations via unique links and QR codes. After scanning the QR code, the user is directed to a personal invitation page with a welcome message, a greeting by name, a photo and a message from the CEO, a countdown… AI Art, Databases & SQL ∙ 15 minutes back ∙ 11 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 4 hours 7 minutes back ∙ 25 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days 4 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 4 days 7 hours back ∙ 19 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 7 days 7 hours back ∙ 13 proposals |