Attached is a picture of the schema/question and the table I've been using as a reference to test my questions. I'm stuck on parts D and E of a homework problem. I'm trying to solve D with nested queries but really struggle with the concept of multiple negations (curse you De Morgan). And for part E I'm not sure how I'd go about comparing the average over an entire type to each individual loan. I know part D's answer based on the table I have should just be Smith, but I'm having a hard time isolating borrower cnames with loan types. For part E, I believe with the attached table I would get jumbo mortgage as an answer. Not sure how to get these though.

customer (name: string, credit: integer) loan (no: string, type: string, minCredit: integer) borrower (cname: string, Ino; string, due: date) (d) List the customers who took every type of loan (at least one loan from every type). The output schema should be (name (e) List the loans who have a strictly greater number of borrowers than the average number of borrowers over all loans of that type. The output schema should be (no