Dayforce Interview Question

Sql query on topic called subqueary