SQL> SQL> start lab6 COUNT(*) ---------- 12 SUM(G.PRICE) ------------ 119.92 FIRSTNAME LASTNAME NUMBER_OF_PURCHASES -------------------- -------------------- ------------------- TRAVIS ESPOSITA 6 CUC HAFFERKAMP 6 SIXTA ENGLEY 6 TERRELL ARZT 6 NATACHA STENZ 7 CHARLENE MESDAQ 7 MIGDALIA STADICK 7 MELLIE MCMAHAN 7 CORETTA DUKELOW 8 ALMETA DOMKOWSKI 8 KIP ARNN 9 OSVALDO DUNLOW 10 JULIET LOGAN 11 DAVID CALLENDAR 11 ARIANE CRUZEN 11 JOSETTE SLINGLAND 15 RAYFORD SOPKO 15 SHARRON TOUSSAND 16 STEPHEN ZEME 16 RUPERT HELING 18 20 rows selected. MAX(P.RNUM) ----------- 18 MIN(P.INUM) ----------- 13 MAX(S.SPENT) MIN(S.SPENT) AVG(S.SPENT) ------------ ------------ ------------ 206.61 45.19 109.893 FIRSTNAME LASTNAME COUNT(*) SUM(G.PRICE) -------------------- -------------------- ---------- ------------ DAVID CALLENDAR 18 66.44 RAYFORD SOPKO 47 147.6 JOSETTE SLINGLAND 43 190.41 STEPHEN ZEME 39 137.16 SHARRON TOUSSAND 40 187.7 RUPERT HELING 55 206.61 JULIET LOGAN 35 163.19 OSVALDO DUNLOW 29 93.91 ARIANE CRUZEN 34 145.22 9 rows selected. SUM(PRICE) ---------- 127 FOOD SUM(PRICE) -------------------- ---------- Cookie 97.67 Tart 528.75 Pie 68.25 Croissant 106.1 Cake 1126.64 Danish 44.85 Bear Claw 37.05 Twist 20.7 Eclair 126.75 Meringue 41.1 10 rows selected. FOOD -------------------- Cake SQL> spoll off SP2-0042: unknown command "spoll off" - rest of line ignored. SQL> spool off