SQL> start lab1-solution FIRSTNAME LASTNAME -------------------- -------------------- ARIANE CRUZEN FIRSTNAME LASTNAME COUNT(*) -------------------- -------------------- ---------- STEPHEN ZEME 5 SALEDATE TOTAL_FOR_CAKES --------- --------------- 04-OCT-07 87.7 12-OCT-07 100.65 19-OCT-07 89.24 SALEDATE RNUMBER FLAVOR FOOD PRICE --------- ---------- -------------------- -------------------- ---------- 09-OCT-07 77406 Opera Cake 15.95 14-OCT-07 29908 Strawberry Cake 11.95 FOOD FLAVOR PRICE -------------------- -------------------- ---------- Cake Casino 15.95 Cake Opera 15.95 Cake Truffle 15.95 SALEDATE NUMPURCHASES --------- ------------ 12-OCT-07 5 SQL> spool off