LTM Limited interview question

Write SQL queries for the tables provided.