SQL> start lab6 AGEGROUP S COUNT(*) -------- - ---------- 01-19 F 1 50-59 M 35 99-+ M 1 50-59 F 3 40-49 F 26 60-98 M 7 20-39 M 158 20-39 F 114 01-19 M 4 40-49 M 113 99-+ F 1 11 rows selected. ST COUNT(*) -- ---------- FL 1 MA 4 CT 1 RI 5 TOWN MAX(PLACE) -------------------- ---------- PEACEDALE 259 GREENWICH 407 PORTSMOUTH 286 N KINGSTOWN 449 WARWICK 413 RIVERSIDE 189 PASCOAG 421 WAKEFIELD 368 RUMFORD 186 W KINGTON 438 LITTLE COMPTON 37 BRISTOL 347 N SMITHFIELD 440 PROVIDENCE 76 WEST WARWICK 460 KINGSTON 288 EAST PROV 455 WICKFORD 351 W WARWICK 384 PROV 195 NORHT PROV 431 NEWPORT 177 SMITHFIELD 337 NPT 452 GLOCESTER 280 CANTON 448 N SCITUATE 364 CRANSTON 458 NARR 214 SAUNDERSTOWN 270 E PROVIDENCE 434 BARRINGTON 244 SAUNDERTOWN 242 NARRAGANSETT 405 PAWT 382 TIVERTON 404 WARREN 450 CUMB 417 JOHNSTON 409 W KINGSTON 246 FOSTER 427 WESTERLY 90 HOPE 356 COVENTRY 399 PROVIDNCE 395 N PROV 332 PAWTUCKET 424 RICHMOND 441 CAROLINA 451 SCITUATE 429 CUMBERLAND 422 GREENVILLE 400 LINCOLN 461 E GREENWICH 306 KINGSTOWN 371 55 rows selected. AGE FIRSTNAME LASTNAME PLACE ---------- -------------------- -------------------- ---------- 16 STANFORD RIVERIA 212 17 NAPOLEON FUJII 254 18 KENDRICK HOLZ 16 21 ANDRES AMOE 22 22 JAMES SAMANTHA 13 23 AL LEMASTER 5 24 JARVIS STONECYPHER 37 25 JAIME BROUGHTON 79 26 MOHAMMED BLAZEK 40 27 MILES ROSELLA 3 28 SCOTT HUMETEWA 38 29 HORACE KARPOWICZ 2 30 MARK COUTERMARSH 27 31 HERSHEL MACHINSKY 14 32 GRANVILLE REVEAL 28 33 BRADLY WAGMAN 15 34 EZRA ITTNER 18 35 FRANKLYN GIRARDIN 4 36 JAMA PEAD 17 37 ANDRE PELLAM 1 38 DEWEY HEAIVILIN 7 39 ABE VIELLE 12 40 TED HARRELSON 21 41 BRENTON FAGO 9 42 BRANDON KRASNOW 46 43 BROOKS THIELEMIER 95 44 JESSE FRENNER 31 45 WILBER VANORDER 11 46 CRUZ TAILOR 6 47 IKE DAWSON 57 48 OMAR MELLOS 23 49 FLORIDA AYTES 75 50 GIOVANNI FYLES 102 51 ALEXIS HABERMANN 36 52 HEATH KIRVIN 70 53 MODESTO PENBERTHY 192 54 WESLEY BECKWORTH 105 55 EMORY BRODISH 190 56 SILAS CHALENDER 197 57 FRANCIS LAMSON 41 58 KIRK DESAUTELLE 394 60 AUGUSTUS VANDAL 369 61 CEDRIC FROILAND 128 62 BRENDAN MARUCO 327 64 ANTONY CRAGIN 215 65 JARROD ASKAM 292 74 PORTER KIKUCHI 405 99 JOSUE WOODAL 149 48 rows selected. FIRSTNAME LASTNAME TOWN ST PLACE -------------------- -------------------- -------------------- -- ---------- ANDRE PELLAM HALIFAX MA 1 HORACE KARPOWICZ BREWSTER MA 2 MILES ROSELLA PEACEDALE RI 3 FRANKLYN GIRARDIN N PROV RI 4 AL LEMASTER WESTERLY RI 5 CRUZ TAILOR SAUNDERTOWN RI 6 DEWEY HEAIVILIN ST CHARLES MO 7 HYMAN CURIE WRENTHAM MA 8 BRENTON FAGO WESTERLY RI 9 CHARLES FARLESS CRANSTON RI 10 WILBER VANORDER W YARM MA 11 ABE VIELLE DEERFIELD NH 12 JAMES SAMANTHA RICHMOND RI 13 HERSHEL MACHINSKY JOHNSTON RI 14 BRADLY WAGMAN CAMBRIDGE MA 15 KENDRICK HOLZ PROV RI 16 JAMA PEAD NEPTUNE BEACH FL 17 EZRA ITTNER CANTON RI 18 ROMEO UNVARSKY NPT RI 19 19 rows selected. SQL> spool off