BeezUP interview question

Write a SQL query to get some data form the following tables.