AJ DEVTECH interview question

SQL joins query. Php questions