SQL
SQL JOIN types: how I combine tables and check the result
Two tables, one JOIN and suddenly revenue doubles. Unfortunately, only in the report. Here is how I choose a join for the question and check that the result still represents the right things.