eQ Technologic interview question

DBMS queries based on joins.