derrick-ryan-giggs

From products, return the top 3 categories by average price

From products, return category, COUNT(*) AS total, and SUM(CASE WHEN rating >= 4 THEN 1 ELSE 0 END)

From products, return category and the distinct count of in_stock values per category as stock_varia

For each department in employee_metrics, calculate the average metric_value and the median metric_va

Calculate the median transaction amount (50th percentile) and the 95th percentile transaction amount

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.

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