[Solved] What will this query return?SELECT COUNT(*) FROM Employees WHERE Department = 'Sales'; — Ans: Number of employees in Sales department | SQL

SQL - Aggregate Functions

What will this query return?

SELECT COUNT(*) FROM Employees WHERE Department = 'Sales';

ANumber of employees in Sales department

BList of all employees

CSum of employee salaries

DError due to missing GROUP BY

Step-by-Step Solution

Solution:

Step 1: Understand COUNT(*) with WHERE clause
COUNT(*) counts rows that match the condition Department = 'Sales'.
Step 2: Identify what the query returns
The query returns a single number: how many employees are in Sales.
Final Answer:
Number of employees in Sales department -> Option A
Quick Check:
COUNT(*) with WHERE = filtered row count [OK]

Quick Trick: COUNT(*) counts rows matching conditions [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will this query return?