HirePro Interview Question

SQL query using join and sub query