Hansa Cequity interview question

SQL, joins