SABA INDOMEDIKA interview question

Can you solve this SQL query