--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;

--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;