o9 Solutions interview question

One of the key questions was a JOIN-based SQL scenario where I had to retrieve specific data from two related tables using the correct join condition.