aurelian_07

Show each product's product_name, rating, and the result of converting any 0 rating to NULL using NU

Count the number of users whose email is either NULL or an empty string.

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.