Average sales by year & model
JOIN dimension, EXTRACT year, AVG — GM “sales analytics” shape
SQL drill • JOIN + GROUP BY + date
sales(sale_id, model_id, sale_date, amount) and models(id, model_name).
Report average sale amount per model name and calendar year (from sale_date).
Same pattern covers SUM for “total sales by year/model” — swap the aggregate.
Grain
(model_name, yr) → AVG(amount)
(model_name, yr) → AVG(amount)
Step 0/5Line —
Join + calendar year + AVG
Press Step or Play.
Ready
Join first so every sale row carries a human-readable model dimension.