saber

Combine all content items of type 'article' and type 'video' into a single result set using UNION AL

Use a CTE to find sessions longer than 2000 seconds and show the username for each

Use two CTEs to find users who spent more than $1000 total across all transactions

Use a CTE to find active users who signed up on or after January 1, 2024

Use a derived table (subquery in FROM) to count occurrences of each event type, then show only those

Show each product's name and price alongside the overall average price of all products

Find users who have made a transaction exceeding $500 using a subquery

Top N Per Group: Beginner

Window Functions: Beginner, ROW_NUMBER Challenge 4

Window Functions: Beginner, PARTITION BY Deep Dive Challenge 2