GROUP BY is a supported SQL construct.

• A. Depends
• B. False
• C. Not specified
• D. True

Answer: (D)

Grouping data is a fundamental SQL feature that lets you collapse rows into meaningful summaries. GROUP BY takes one or more expressions and collects all rows that share the same values for those expressions into a single group. Within each group you typically compute aggregates like COUNT, SUM, AVG, MAX, or MIN. Because the SQL standard defines this construct and major databases implement it, GROUP BY is supported across SQL databases. For example: SELECT department, COUNT(*) AS employees FROM employees GROUP BY department; This yields a count of employees per department. In standard SQL, every column in the SELECT list must be either in the GROUP BY list or be the result of an aggregate function; some dialects allow deviations, but the canonical behavior is that GROUP BY exists and is supported. Therefore the statement is true.