Which of the following is the correct syntax to find the average of the column score in table TestResults?

easy📝 Syntax Q3 of 15

SQL - Aggregate Functions

Which of the following is the correct syntax to find the average of the column score in table TestResults?

ASELECT MEAN(score) FROM TestResults;

BSELECT AVG(score) FROM TestResults;

CSELECT score.AVG() FROM TestResults;

DSELECT AVERAGE(score) FROM TestResults;

Step-by-Step Solution

Solution:

Step 1: Recall correct AVG() usage
AVG() is used as SELECT AVG(column) FROM table; to get average values.
Step 2: Identify invalid syntax
AVERAGE(), MEAN(), and method call syntax like score.AVG() are not valid SQL syntax.
Final Answer:
SELECT AVG(score) FROM TestResults; -> Option B
Quick Check:
Correct AVG() syntax = SELECT AVG(score) FROM TestResults; [OK]

Quick Trick: AVG() is a function, use SELECT AVG(column) FROM table [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes