Complex~38min
The Double Dipper
Two people appear in both the permanent payroll and the contractor invoice system for the same months. Different bank accounts. Same PAN numbers.
Tables you'll query
permanent_employeespayroll_entriescontractorscontractor_invoices
What you'll learn
JOINsSubqueriesAggregations & GROUP BYUNION / INTERSECT / EXCEPT