Pregunta de entrevista de Persistent Systems

basic sql question, queries, joins