level_eagle_1614

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

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

Show each transaction's transaction_date, total_amount, and a running total of total_amount ordered

Rank products by price from highest to lowest within each category using DENSE_RANK()

Assign a dense rank to products by price from highest to lowest, so tied prices share a rank and the

Rank products by their rating from highest to lowest using RANK()