crisp_peak_5015

For each product category, show total_revenue and num_transactions, ordered by total_revenue descend

Find the top 3 users by total spending, ordered from highest to lowest.

For each cloud provider, estimate the number of distinct service names using APPROX_DISTINCT.

Use APPROX_DISTINCT to estimate the number of unique users who have made transactions.

Find the number of distinct product categories in the products table.

For each ad campaign, count the total number of impressions and the number of distinct users who saw

Count the total number of users and how many have an email address on file (non-NULL email)

Rank categories by in-stock product count

From products, return product_id, price, and a band column using CASE: 'cheap' if price < 20, 'mid'

From products, return product_id and product_name where product_name LIKE '%Pro%'