mjmonte

Use a CTE to count each user's transactions, then show usernames with 3 or more transactions

Show the top 5 products by price, sorted from most expensive to least expensive

Stack severe logs into one alert feed

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