The goal is to find the total number of transactions for each user using data from two tables, "users" and "transactions". The "users" table has columns for id and name , while the "transactions" table has columns for id, user_id, and amount. The expected output is a table with columns for id, name, and total_transactions.
The candidate's solution is correct and uses a LEFT JOIN to ensure that all users are included in the result, even if they have no transactions.
Evaluated at: 2022-11-17 23:47:26