LigaDATA interview question

Write SQL queries for data retrieval on example tables