Solution:Step 1: Identify columns in the viewThe view has columns: department and emp_count only.Step 2: Check each query's column usageSELECT department, salary FROM dept_count; tries to select 'salary' which does not exist in the view, causing an error.Final Answer:SELECT department, salary FROM d

[Solved] You have this view:CREATE VIEW dept_count AS SELECT department, COUNT(*) AS emp_count FROM employees GROUP BY department;Which query will cause an error when run on this view? | SQL

SQL - Views

You have this view:

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

Which query will cause an error when run on this view?

ASELECT department FROM dept_count;

BSELECT department, salary FROM dept_count;

CSELECT emp_count FROM dept_count WHERE department = 'Sales';

DSELECT * FROM dept_count WHERE emp_count > 5;

Step-by-Step Solution

Solution:

Step 1: Identify columns in the view
The view has columns: department and emp_count only.
Step 2: Check each query's column usage
SELECT department, salary FROM dept_count; tries to select 'salary' which does not exist in the view, causing an error.
Final Answer:
SELECT department, salary FROM dept_count; causes error -> Option B
Quick Check:
Querying non-existent column = error [OK]

Quick Trick: Select only columns defined in the view [OK]

Common Mistakes:

MISTAKES

Selecting columns not in the view
Assuming all original table columns exist in view
Ignoring GROUP BY effects on columns

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

You have this view:

Step 1: Identify columns in the view

Step 2: Check each query's column usage

Final Answer:

Quick Check:

Want More Practice?