SQL for Real-World Analysis

Your query runs, the totals look plausible, and then someone shows you a different number. This book teaches the habits that stop that from happening. Through one fictional online shop, you learn to define the question and the grain before you write any SQL, profile messy columns, and clean them inside the query so the fix is visible. You then join tables without double counting, aggregate correct...