Pregunta de entrevista de Medidata Solutions

Write SQL query based on two tables.