data_vader

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

For each transaction, show the user's total number of transactions and their total spending across a

For each transaction, show the previous transaction amount for the same user (ordered by transaction

From transactions, return transaction_id, user_id, total_amount, and AVG(total_amount) OVER (PARTITI