Write a query to display the membership number, last name, first name, and total rental fees earned from that membership. (The results are shown in Figure P7.76.) The total rental fee is the sum of...

Write a query to display the membership number, last name, first name, and total rental fees earned from that

membership. (The results are shown in Figure P7.76.) The total rental fee is the sum of all of the detail fees

(without the late fees) from all movies that the membership has rented.