Pergunta de entrevista da empresa Portfolio Aid

Few questions on constructing SQL queries.