Sobes.tech
Intern — Middle

Aggregation of daily sums and number of payments

livecode

Task condition

In the database, there is a table named payment, containing columns: user_id, date, sum. It is required to write an SQL query that will provide two indicators for each date: the total amount of funds and the number of transactions made.