🎴 Flashcard Mode
Database Management Fundamentals: DB2 and Oracle
Card1 / 20
Mastered0
Review0
QuestionClick to flip
SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query :-) ?
AnswerClick to flip back
A
True
💡 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.