Fortunately, SQL offers a number of clauses and operators for sorting, grouping, and summarizing. ... SQL’s ROLLUP operator displays an extra record, a subtotal, for each group.