unique_toucan_7126

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

Engagement Gap

From products, return product_id, category, price, and COUNT(*) OVER (PARTITION BY category) as item

From products, return product_id, category, price, and the RANK within each category ordered by pric

From products, return product_id, category, price, and the row_number within each category ordered b

Show each employee metric's department, metric_value, and the overall average metric_value across al

Show each user session's session_id, user_id, and the total number of sessions for that user