Well, start smaller, and we know this stuff can be frustrating which is why we help.

The query results were correct though, Hopper was the only one with a null return date. You have 2 null RENTAL DATES, but all 3 are populated with RETURN DATES. I think you just have your data in the wrong place...the query returned exactly what it was supposed to. Problem is you have 3 returns, but only 1 rental date.

Do simple queries from Customers and Rentals joining on CustomerID.

Bring back all the records from each so you can see how the query system works.

Have a multi table joined query right out of the gate is like going from Kindergarten to the 8th grade right away.


Since this is homework, basically, no one here can really do it for you (and we know you don't expect us to), but we can certainly point you in the right direction.