Pregunta de entrevista de Portfolio Aid

Few questions on constructing SQL queries.