Infosys Interview Question

Write 5 SQL queries on the given questions