Portfolio Aid interview question

Few questions on constructing SQL queries.