Bird
0
0

What result does this query produce?

medium📝 query result Q5 of 15
SQL - Subqueries
What result does this query produce?
SELECT product_name FROM products WHERE price < (SELECT AVG(price) FROM products)
AProducts priced above the average price
BProducts priced below the average price
CAll products regardless of price
DSyntax error due to missing parentheses
Step-by-Step Solution
Solution:

  1. Step 1: Analyze the subquery

    The subquery calculates the average price of all products.

  2. Step 2: Analyze the main query condition

    The main query selects products with price less than the average price from the subquery.

  3. Final Answer:

    Products priced below the average price -> Option B

  4. Quick Check:

    Subquery returns average, main query filters below average [OK]
Quick Trick: Use subqueries to compare values like averages [OK]
Common Mistakes:
MISTAKES
  • Confusing less than with greater than
  • Assuming syntax error without checking parentheses
  • Thinking it returns all products

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - Why aggregation is needed - Quiz 9hard Aggregate Functions - AVG function - Quiz 2easy Aggregate Functions - MIN and MAX functions - Quiz 12easy GROUP BY and HAVING - GROUP BY with ORDER BY - Quiz 9hard GROUP BY and HAVING - How GROUP BY changes query execution - Quiz 14medium GROUP BY and HAVING - GROUP BY with ORDER BY - Quiz 6medium INNER JOIN - INNER JOIN with table aliases - Quiz 14medium LEFT and RIGHT JOIN - LEFT JOIN preserving all left rows - Quiz 11easy Table Relationships - One-to-many relationship design - Quiz 13medium Views - Dropping and altering views - Quiz 9hard