Bird
0
0

Find the error in this query: SELECT AVG(salary FROM Employees;

medium📝 Debug Q7 of 15
SQL - Aggregate Functions
Find the error in this query: SELECT AVG(salary FROM Employees;
AMissing closing parenthesis for AVG()
BAVG() cannot be used on salary
CEmployees table does not exist
DAVG() requires GROUP BY clause
Step-by-Step Solution
Solution:

  1. Step 1: Check parentheses balance

    AVG() function requires opening and closing parentheses around the column.

  2. Step 2: Identify missing closing parenthesis

    The query misses the closing parenthesis after salary.

  3. Final Answer:

    Missing closing parenthesis for AVG() -> Option A

  4. Quick Check:

    Parentheses must be balanced in AVG() [OK]
Quick Trick: Check parentheses carefully in functions [OK]
Common Mistakes:
MISTAKES
  • Forgetting closing parenthesis
  • Misplacing parentheses in function calls

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Joins - FULL OUTER JOIN behavior - Quiz 14medium Aggregate Functions - COUNT(*) vs COUNT(column) difference - Quiz 8hard GROUP BY and HAVING - HAVING clause for filtering groups - Quiz 3easy INNER JOIN - INNER JOIN with multiple conditions - Quiz 7medium INNER JOIN - INNER JOIN with table aliases - Quiz 2easy LEFT and RIGHT JOIN - Finding unmatched rows with LEFT JOIN - Quiz 11easy LEFT and RIGHT JOIN - RIGHT JOIN execution behavior - Quiz 4medium Set Operations - EXCEPT (MINUS) for differences - Quiz 5medium Table Relationships - One-to-one relationship design - Quiz 14medium Views - View as a saved query mental model - Quiz 13medium