Infosys Interview Question

Was asked to write a SQL query, mentioned some constraints and given two tables supposed to use "join"