Pregunta de entrevista de BeezUP

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