The query was:
SELECT COUNT(*) FROM employees HAVING COUNT(*) > 0;
Our active members picked B) 1, C) 0 or D) Error… but let’s break it down real quick! ⚡
➡️ COUNT(*) in the SELECT counts ALL rows in the table → with 10 rows it returns 10
➡️ The HAVING clause filters after aggregation
➡️ HAVING COUNT(*) > 0 simply checks if the total count is greater than 0 (which it always is unless the table is empty)
🟢 So the query returns exactly one row with the value 10.
The question was a valid (just a bit tricky/wordy) way to write
give me the total row count, but only if there’s at least one row
Correct answer: A) 10 ✅
Unfortunately no one got it right😅
Better luck next time folks, you’re all still SQL legends in my book! 💙