Deloitte Interview Question

Perform some joins group bys and manage null values