Portfolio Aid Interview Question

Few questions on constructing SQL queries.