Absa interview question

Code using one SQL to run some joins