Track the last 3 jobs each user launched and their status, sorted by launch date
From DataLemur Databricks SQL questions page. Schema: Users(user_id, account_created_date, last_login), Jobs(job_id, user_id, launched_date, description, status). Expected approach: use ROW_NUMBER() window function partitioned by user_id ordered by launched_date DESC, then filter for row_number <= 3 in outer query. Output sorted by launched_date descending.