I have a class project where I'm responsible for coming up with the following query and I'm not sure where to start... Type of... If/then statement, while loop and so on...

"Write a query that...