FIS interview question

Scenario based join queries in DBMS