User Engagement Score

Challenge brief

Understand the request

Customer Success is building a product health score for each customer and needs total usage time as the primary engagement signal.

Sum usage_minutes per user_id from usage_logs.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

SELECT u.user_id, COALESCE(SUM(ul.usage_minutes), 0) AS total_usage FROM users u LEFT JOIN usage_logs ul ON u.user_id = ul.user_id GROUP BY u.user_id ORDER BY u.user_id;

Expected result

Use this output to verify values, aliases, ordering, and row count.

Previewing 10 of 13 expected rows. Run the query in the editor to inspect the full result.