SQL - Aggregate Functions
Which SQL statement correctly computes the average cost from a table named
Inventory?Which SQL statement correctly computes the average cost from a table named Inventory?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify correct function
SQL uses AVG() to calculate average values.Step 2: Check syntax
SELECT AVG(cost) FROM Inventory; is correct syntax.Step 3: Evaluate other options
AVERAGE() and MEAN() are invalid SQL functions; SELECT SUM(cost)/COUNT(*) FROM Inventory; calculates average manually but is less efficient.Final Answer:
SELECT AVG(cost) FROM Inventory; -> Option BQuick Check:
AVG() is standard average function [OK]
Quick Trick: Use AVG() to calculate average in SQL [OK]
Common Mistakes:
MISTAKES- Using non-existent functions like AVERAGE() or MEAN()
- Trying to manually calculate average instead of using AVG()
- Syntax errors in function usage
Master "Aggregate Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes