Portfolio Aid interview question

write sql queries for those 3 problems.