Write a query to display the membership number, last name, and total rental fees earned from that membership (result shown in Figure.). 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.

Transcribed Image Text:

Mem LName Mem FName Rental Fee Revenue 5.5 7.5 3.5 Mem Num 102 Dawson 103 Knight 104 Melendez 105 McClair 107 Elliott 110 Rosales 111 Mann Tami Curt Jamal lva Rosaio Lewis Stacy 5.5