SABA INDOMEDIKA Interview Question

Can you solve this SQL query