Quantiphi interview question

SQL Queries inner and outer joins