Exercise: ROW_NUMBER

For each stream by user_id 1, return stream_id, started_at, and a row number rn ordered by started_at ASC. Order by started_at.

Return every artist with their name and a row number rn assigned alphabetically by name. Order the result by rn.

Find each user's most recent stream. Return user_id, stream_id, and started_at. Use ROW_NUMBER with PARTITION BY user_id ORDER BY started_at DESC, stream_id DESC and keep only rn = 1. Order by user_id.

For each user where user_id IN (1, 2, 3), return the first 2 streams (ordered by started_at). Show user_id, stream_id, started_at, and rn. Order by user_id, rn.

For each user where user_id IN (1, 2, 4), return the top 2 longest streams ordered by duration_listened DESC, with stream_id ASC as a tiebreaker. Show user_id, stream_id, duration_listened, and rn. Order by user_id, rn.