Twilio interview question

SQL QUERY With left joins