--28 v1
SELECT M.MEM_NUM AS "Member #", M.LNAME||', '||M.FNAME AS "Customer Name", COUNT(D.GC_NUM) AS "# Games Rented"
FROM Membership M
   INNER JOIN RENTAL R ON R.MEM_NUM=M.MEM_NUM
      INNER JOIN Detailrental D ON R.RENT_NUM=D.RENT_NUM
GROUP BY M.MEM_NUM,M.LNAME,M.FNAME;

--
Memb Customer Name                                                  # Games Rented
---- -------------------------------------------------------------- --------------
102  DAWSON, TAMI                                                                3
103  KNIGHT, CURT                                                                3
104  MELENDEZ, JAMAL                                                             1
105  MCCLAIN, IVA                                                                2
107  ELLIOTT, ROSARIO                                                            2
110  ROSALES, LEWIS                                                              3
111  MANN, STACY                                                                 3

7 rows selected.
--


--v2
SELECT M.MEM_NUM AS "Member #", M.LNAME||', '||M.FNAME AS "Customer Name", COUNT(D.GC_NUM) AS "# Games Rented", SUM(P.RENT_FEE) AS "Rental Fee"
FROM Membership M
   INNER JOIN RENTAL R ON R.MEM_NUM=M.MEM_NUM
      INNER JOIN Detailrental D ON R.RENT_NUM=D.RENT_NUM
         INNER JOIN Gamecopy GC ON D.GC_NUM=GC.GC_NUM
            INNER JOIN GAME G ON GC.GA_NUM=G.GA_NUM
               INNER JOIN PRICE P ON G.PRICE_CODE=P.PRICE_CODE
GROUP BY M.MEM_NUM,M.LNAME,M.FNAME;

--
Memb Customer Name                                                  # Games Rented Rental Fee
---- -------------------------------------------------------------- -------------- ----------
102  DAWSON, TAMI                                                                3        7.5
103  KNIGHT, CURT                                                                3        8.5
104  MELENDEZ, JAMAL                                                             1          2
105  MCCLAIN, IVA                                                                2          4
107  ELLIOTT, ROSARIO                                                            2        4.5
110  ROSALES, LEWIS                                                              3          8
111  MANN, STACY                                                                 3        8.5

7 rows selected.
--