Infosys interview question

Mostly project based questions. Some sql queries.