'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That

Adapted from the SQL Essentials Companion Guide. You add one more column to a GROUP BY query, run it, and get this instead of results: ERROR: column "products.name" must appear in the GROUP BY clause