GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

By the end of this page you can write a summary query and know its answer is real. You will know exactly what GROUP BY does to your rows, which columns you are allowed to select afterwards and why, wh