Intern — Middle
Counting the total amount of transactions for each user
livecode
Task condition
It is necessary to output the total amount of all transactions performed by each user.
There are three tables:
- users (user_id, phone, name, age, email)
- accounts (account_id, user_id, created_by, changed_by)
- operations (account_id, amount, operation_time, operation_id)