Click image for larger version. 

Name:	2015-11-23 08.47.51.png 
Views:	6 
Size:	743.8 KB 
ID:	16647

I did an assignment for a class which I think is right, but I want to resubmit because I feel like in one of the parts of my assignment I can condense the 4 queries I made into 2. I have attached it and was wondering if anyone could guide me into how I can combine the first 3 queries. Basically I am supposed to create a query that will show a customer their transaction history at a store including purchases, returns, and rentals.