Multiple choice technology databases

SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is a valid and well-structured SQL query. It filters employees by salary (>25000), groups by department, and counts employees in each department using COUNT(1). The syntax is correct across all major SQL databases. The emoticon ':-)' suggests the question is asking if the query is valid.

Keep practicing — related questions