Anonymous interview question

SQL questions on joins basics