Absa Interview Question

Code using one SQL to run some joins