lab6-BAKERY-results

Lab6-BAKERY-results - FIRSTNAME LASTNAME COUNT SUM(G.PRICE DAVID.44 RAYFORD.6 JOSETTE.41 STEPHEN.16 SHARRON.7 RUPERT.61 JULIET.19 OSVALDO.91

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> SQL> start lab6 COUNT(*) ---------- SUM(G.PRICE) ------------ 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) ----------- MIN(P.INUM) ----------- MAX(S.SPENT) MIN(S.SPENT) AVG(S.SPENT) ------------ ------------ ------------ 206.61 45.19 109.893
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Sheet1 Page 2
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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) ---------- 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...
View Full Document

This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.

Page1 / 2

Lab6-BAKERY-results - FIRSTNAME LASTNAME COUNT SUM(G.PRICE DAVID.44 RAYFORD.6 JOSETTE.41 STEPHEN.16 SHARRON.7 RUPERT.61 JULIET.19 OSVALDO.91

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online