Warehouse SQL Patterns

SELECT d.month_name,
       dp.category,
       SUM(f.amount) AS revenue,
       SUM(f.quantity) AS units
FROM fact_sales f
JOIN dim_date d    ON d.date_key = f.date_key
JOIN dim_product dp ON dp.product_key = f.product_key
GROUP BY d.month_number, d.month_name, dp.category
ORDER BY d.month_number, revenue DESC;

SQL editor. Press Command or Control plus Enter to execute. Suggestions appear as you type; use the arrow keys to choose one and Enter or Tab to insert it, or Escape to dismiss.