How to Avoid GROUP BY Returning Random Rows

Non-aggregated columns can return garbage.

#mysql #groupby #bug #howto #sqlmode #analytics

https://www.youtube.com/watch?v=mKt4TxGkaAU