Last Updated: May 12, 2026
For this exercise, we will work with below data:
Find the smallest and largest payment amounts in the payments table. Return them as min_amount and max_amount.
Find the earliest and most recent signup dates from the users table. Return them as first_signup and last_signup.
Find the track with the shortest duration. Return the track_id, title, and duration_seconds. Handle ties by returning all tracks that share the minimum.
Find the user who signed up most recently. Return the username and signup_date.
Find the maximum payment amount. When multiple payments share the maximum amount, return only the most recent one as a tiebreaker. Return the payment_id, username, amount, and payment_date.