Create a SQL request
5 USD 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.
-
1 day5 USD
354 2 0 1 day5 USD
Send a Dump to the Face.
........................................................
-
1 day5 USD
245 4 0 1 day5 USD
Good day . Ready to fulfill your order! Contact us, I will be happy to collaborate!
-
1 day5 USD
2084 226 0 1 1 day5 USD
Hello to you. I will help with the request. Remove the Dump Base in the Face.
-
1 day5 USD
2657 427 9 1 1 day5 USD
Готов сделать
=- = -= - =- =- =- =- = -= -= -= -= -= - =- =- =- = -= -= -= -= -= - =- =- =- = -= -= -= - =- =- = -= -=-
-
Winning proposal1 day5 USD
426 16 0 Winning proposal1 day5 USD
Hello to you! A simple task. Please send the Dump, I will send the work outcome. I do in urgent order!
-
1 day5 USD
385 14 1 1 day5 USD
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
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 2 hours 35 minutes back ∙ 5 proposals |
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 ∙ 5 hours 45 minutes back ∙ 31 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 ∙ 9 hours 36 minutes back ∙ 28 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About 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 9 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 12 hours back ∙ 19 proposals |
Ukraine