Shipsy interview question

Few questions on DBMS (theoretical + SQL query)