Infosys interview question

Write 5 SQL queries on the given questions