SQL-BASICS5 MIN READ
Average Is Not Always the Metric
Explain when AVG is the wrong aggregate and choose a metric-aligned alternative.
Luis L Sales Lead W Weight G Grain Q Query Metric ask 20 sec The request Luis asks for average discount by region before a pricing review. The source table is opportunity line items. If line items are the weight by accident, enterprise deals dominate the answer. pricing decision line source grain
Read the full lesson
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in