Quiz for HAVING Clause

Q1: Which clause is used to filter records after aggregation in SQL?

A. WHERE B. HAVING C. GROUP BY D. JOIN

Q2: Which clause is used to filter records after GROUP BY is applied?

A. WHERE B. GROUP BY C. HAVING D. ORDER BY

Q3: Which of the following is valid in a SQL statement?

A. GROUP BY after HAVING B. HAVING after GROUP BY C. HAVING before SELECT D. HAVING before FROM

Q4: Can we use aggregate functions in the HAVING clause?

A. Yes B. No C. Only in SELECT D. Only with WHERE

Q5: What will this query return: SELECT dept, COUNT(*) FROM emp GROUP BY dept HAVING COUNT(*) > 5?

A. Departments with more than 5 employees B. All departments C. Departments with less than 5 employees D. Syntax error

Q6: What happens if we use HAVING without GROUP BY?

A. Error occurs B. Acts like WHERE C. Filters all rows D. Filters on columns

Q7: Which of the following is NOT allowed in a HAVING clause?

A. SUM(salary) > 10000 B. AVG(age) < 30 C. name = "John" D. COUNT(id) >= 2

Q8: HAVING is typically used with which SQL clause?

A. WHERE B. ORDER BY C. GROUP BY D. DISTINCT

Q9: In what scenario would you use HAVING instead of WHERE?

A. To filter rows before aggregation B. To filter individual columns C. To filter grouped results D. To filter sorted data

Q10: Which is a correct SQL statement using HAVING?

A. SELECT COUNT(*) FROM emp HAVING salary > 1000 B. SELECT name FROM emp HAVING name = "Amit" C. SELECT dept, COUNT(*) FROM emp GROUP BY dept HAVING COUNT(*) > 2 D. HAVING salary FROM emp > 1000

Q11: HAVING clause filters which type of data?

A. Row-level data B. Aggregated/grouped data C. Columns only D. Unsorted data

Q12: Can we use HAVING clause with multiple conditions?

A. No B. Yes, using AND/OR C. Only one condition allowed D. Only AND allowed

Q13: Which query returns groups where SUM(salary) is more than 50000?

A. SELECT dept FROM emp HAVING SUM(salary) > 50000 B. SELECT dept FROM emp WHERE SUM(salary) > 50000 C. SELECT dept, SUM(salary) FROM emp GROUP BY dept HAVING SUM(salary) > 50000 D. SELECT SUM(salary) FROM emp WHERE dept GROUP BY

Q14: HAVING clause is used with which clause to perform filtering?

A. SELECT B. FROM C. GROUP BY D. WHERE

Q15: Choose the correct SQL syntax using HAVING.

A. SELECT age FROM users HAVING age > 30 B. SELECT dept, COUNT(*) FROM users GROUP BY dept HAVING COUNT(*) >= 2 C. HAVING COUNT(*) > 5 SELECT * FROM users D. SELECT * FROM users HAVING COUNT(*) > 5 GROUP BY dept

Q16: Which keyword cannot be used inside HAVING clause?

A. COUNT() B. SUM() C. WHERE D. AVG()

Q17: HAVING clause comes after which clause in SQL?

A. SELECT B. WHERE C. GROUP BY D. FROM

Q18: Which clause is used for row-level filtering?

A. WHERE B. HAVING C. GROUP BY D. DISTINCT

Q19: Can HAVING be used in SELECT without aggregation?

A. Yes B. No C. Only with DISTINCT D. Only with ORDER BY

Q20: What is the output of: SELECT dept, SUM(salary) FROM emp GROUP BY dept HAVING SUM(salary) > 100000?

A. Employees with salary over 100000 B. All employees C. Departments with total salary > 100000 D. Syntax error

Q21: Which clause should be used to restrict groups in SQL?

A. WHERE B. HAVING C. GROUP BY D. ORDER BY