Solution:Step 1: Understand the view's aggregationThe view groups employees by department and counts employees per department.Step 2: Apply the query filterThe query selects departments where emp_count (number of employees) is greater than 5.Final Answer:Departments with more than 5 employees -> Opt

[Solved] Consider the view:CREATE VIEW employee_summary AS SELECT department, COUNT(*) AS emp_count FROM employees GROUP BY department;What will the query SELECT * FROM employee_summary WHERE emp_count > 5;... | SQL

SQL - Views

Consider the view:

CREATE VIEW employee_summary AS SELECT department, COUNT(*) AS emp_count FROM employees GROUP BY department;

What will the query SELECT * FROM employee_summary WHERE emp_count > 5; return?

ADepartments with more than 5 employees

BEmployees with salary greater than 5

CAll employees regardless of department

DDepartments with exactly 5 employees

Step-by-Step Solution

Solution:

Step 1: Understand the view's aggregation
The view groups employees by department and counts employees per department.
Step 2: Apply the query filter
The query selects departments where emp_count (number of employees) is greater than 5.
Final Answer:
Departments with more than 5 employees -> Option A
Quick Check:
Filter on aggregated count = departments with emp_count > 5 [OK]

Quick Trick: Filters on views apply to the view's result set [OK]

Common Mistakes:

MISTAKES

Confusing emp_count with salary
Ignoring GROUP BY effect
Assuming emp_count is employee ID

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider the view:

Step 1: Understand the view's aggregation

Step 2: Apply the query filter

Final Answer:

Quick Check:

Want More Practice?