Total revenue per user

In sales(id, user_id, product, amount, ts) compute the total purchase amount for each user. Group rows by user_id and return columns user_id and total_amount (sum of amount). Order the result by user_id ascending.