Two SQL shapes that stopped a text-to-SQL agent doing arithmetic in prose — ROLLUP and scalar subqueries
A text-to-SQL agent broke a written rule against adding rows by hand. GROUP BY ROLLUP and scalar subqueries fixed it by deleting the step, not the rule.