Pregunta de entrevista de IBM

Given data, use SQL to make a specific query.