Traps & Trick QuestionsEasy
Does AVG(col) equal SUM(col)/COUNT(*)?
Seen at: Amazon · Meta
Your manager runs two queries against the same orders table:
SELECT AVG(discount) FROM orders;
SELECT SUM(discount) / COUNT(*) FROM orders;
They return different numbers. Why?
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Stuck? Peek at a hint
Reveals the model answer and the self-score rubric.