What does the aggregate function do?

Anaggregate functionperforms acalculation over multiple rowsand returns asingle value. Examples includeSUM(), AVG(), MAX(), MIN(), and COUNT()in SQL.

Option A (Correct):Aggregate functions compute values over aset of rows, like summingtotal sales or averaging grades.

Option B (Incorrect):Selecting rows that appear in one table but not another is done usingset operations (EXCEPT or MINUS in SQL).

Option C (Incorrect):Eliminating columns is done using thePROJECToperation orSELECT with specific columns.

Option D (Incorrect):Combining rows from two tables refers to aJOIN operation, not aggregation.