Group by returns wrong products

Review this SQL meant to show each product's latest price and total units sold.

This runs on MySQL with ONLY_FULL_GROUP_BY disabled.