SQL> select * from ppk; POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 1 Bulbasaur 7 69 64 Seed 2 Ivysaur 10 130 141 Seed 3 Venusaur 20 1000 208 Seed POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 4 Charmander 6 85 65 Lizard 5 Charmeleon 11 190 142 Flame 6 Charizard 17 905 209 Flame POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 7 Squirtle 5 90 66 Tiny Turtle 8 Wartortle 10 225 143 Turtle 9 Blastoise 16 855 210 Shellfish POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 10 Caterpie 3 29 53 Worm 11 Metapod 7 99 72 Cocoon 12 Butterfree 11 320 160 Butterfly POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 13 Weedle 3 32 52 Hairy Bug 14 Kakuna 6 100 71 Cocoon 15 Beedrill 10 295 159 Poison Bee POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 16 Pidgey 3 18 55 Tiny Bird 17 Pidgeotto 11 300 113 Bird 18 Pidgeot 15 395 172 Bird POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 19 Rattata 3 35 57 Mouse 20 Raticate 7 185 116 Mouse 21 Spearow 3 20 58 Tiny Bird POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 22 Fearow 12 380 162 Beak 23 Ekans 20 69 62 Snake 24 Arbok 35 650 147 Cobra POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 25 Pikachu 4 60 82 Mouse 26 Raichu 8 300 122 Mouse 27 Sandshrew 6 120 93 Mouse POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- -------------- GENUS -------------------- 28 Sandslash 10 295 163 Mouse 29 Nidoran??? 4 70 59 Poison Pin 30 Nidorina 8 200 117 Poison Pin 30 rows selected. SQL> set linesize 150 SQL> set pagesize 34 SQL> run 1* select * from ppk POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE GENUS ---------- -------------------- ---------- ---------- -------------- -------------------- 1 Bulbasaur 7 69 64 Seed 2 Ivysaur 10 130 141 Seed 3 Venusaur 20 1000 208 Seed 4 Charmander 6 85 65 Lizard 5 Charmeleon 11 190 142 Flame 6 Charizard 17 905 209 Flame 7 Squirtle 5 90 66 Tiny Turtle 8 Wartortle 10 225 143 Turtle 9 Blastoise 16 855 210 Shellfish 10 Caterpie 3 29 53 Worm 11 Metapod 7 99 72 Cocoon 12 Butterfree 11 320 160 Butterfly 13 Weedle 3 32 52 Hairy Bug 14 Kakuna 6 100 71 Cocoon 15 Beedrill 10 295 159 Poison Bee 16 Pidgey 3 18 55 Tiny Bird 17 Pidgeotto 11 300 113 Bird 18 Pidgeot 15 395 172 Bird 19 Rattata 3 35 57 Mouse 20 Raticate 7 185 116 Mouse 21 Spearow 3 20 58 Tiny Bird 22 Fearow 12 380 162 Beak 23 Ekans 20 69 62 Snake 24 Arbok 35 650 147 Cobra 25 Pikachu 4 60 82 Mouse 26 Raichu 8 300 122 Mouse 27 Sandshrew 6 120 93 Mouse 28 Sandslash 10 295 163 Mouse 29 Nidoran??? 4 70 59 Poison Pin 30 Nidorina 8 200 117 Poison Pin 30 rows selected. SQL> select genus, count(*) 2 from ppk 3 group by genus 4 ; GENUS COUNT(*) -------------------- ---------- Lizard 1 Tiny Turtle 1 Turtle 1 Seed 3 Flame 2 Poison Bee 1 Cocoon 2 Snake 1 Poison Pin 2 Bird 2 Mouse 6 Shellfish 1 Worm 1 Hairy Bug 1 Tiny Bird 2 Cobra 1 Butterfly 1 Beak 1 18 rows selected. SQL> select genus, count(*), max(baseexperience), avg(weight) 2 from ppk 3 group by genus 4 ; GENUS COUNT(*) MAX(BASEEXPERIENCE) AVG(WEIGHT) -------------------- ---------- ------------------- ----------- Lizard 1 65 85 Tiny Turtle 1 66 90 Turtle 1 143 225 Seed 3 208 399.666667 Flame 2 209 547.5 Poison Bee 1 159 295 Cocoon 2 72 99.5 Snake 1 62 69 Poison Pin 2 117 135 Bird 2 172 347.5 Mouse 6 163 165.833333 Shellfish 1 210 855 Worm 1 53 29 Hairy Bug 1 52 32 Tiny Bird 2 58 19 Cobra 1 147 650 Butterfly 1 160 320 Beak 1 162 380 18 rows selected. SQL> SQL> select genus, max(baseexperience) 2 from ppk 3 where max(baseexperience) > 100 4 group by genus; where max(baseexperience) > 100 * ERROR at line 3: ORA-00934: group function is not allowed here SQL> select genus, max(baseexperience) as maxB 2 from ppk 3 group by genus 4 having max(baseexperience) > 100 5 ; GENUS MAXB -------------------- ---------- Turtle 143 Seed 208 Flame 209 Poison Bee 159 Poison Pin 117 Bird 172 Mouse 163 Shellfish 210 Cobra 147 Butterfly 160 Beak 162 11 rows selected. SQL> select genus, max(baseexperience) as maxB 2 from ppk 3 group by genus 4 having maxB > 100 5 ; having maxB > 100 * ERROR at line 4: ORA-00904: "MAXB": invalid identifier SQL> select genus, max(baseexperience) 2 from ppk 3 group by genus 4 having count(*) > 1 5 ; GENUS MAX(BASEEXPERIENCE) -------------------- ------------------- Seed 208 Flame 209 Cocoon 72 Poison Pin 117 Bird 172 Mouse 163 Tiny Bird 58 7 rows selected. SQL> SQL> select genus, max(baseexperience), count(*) 2 from ppk 3 group by genus 4 having count(*) > 1 5 ; GENUS MAX(BASEEXPERIENCE) COUNT(*) -------------------- ------------------- ---------- Seed 208 3 Flame 209 2 Cocoon 72 2 Poison Pin 117 2 Bird 172 2 Mouse 163 6 Tiny Bird 58 2 7 rows selected. SQL> select * from ppk; POKEDEXID NAME HEIGHT WEIGHT BASEEXPERIENCE GENUS ---------- -------------------- ---------- ---------- -------------- -------------------- 1 Bulbasaur 7 69 64 Seed 2 Ivysaur 10 130 141 Seed 3 Venusaur 20 1000 208 Seed 4 Charmander 6 85 65 Lizard 5 Charmeleon 11 190 142 Flame 6 Charizard 17 905 209 Flame 7 Squirtle 5 90 66 Tiny Turtle 8 Wartortle 10 225 143 Turtle 9 Blastoise 16 855 210 Shellfish 10 Caterpie 3 29 53 Worm 11 Metapod 7 99 72 Cocoon 12 Butterfree 11 320 160 Butterfly 13 Weedle 3 32 52 Hairy Bug 14 Kakuna 6 100 71 Cocoon 15 Beedrill 10 295 159 Poison Bee 16 Pidgey 3 18 55 Tiny Bird 17 Pidgeotto 11 300 113 Bird 18 Pidgeot 15 395 172 Bird 19 Rattata 3 35 57 Mouse 20 Raticate 7 185 116 Mouse 21 Spearow 3 20 58 Tiny Bird 22 Fearow 12 380 162 Beak 23 Ekans 20 69 62 Snake 24 Arbok 35 650 147 Cobra 25 Pikachu 4 60 82 Mouse 26 Raichu 8 300 122 Mouse 27 Sandshrew 6 120 93 Mouse 28 Sandslash 10 295 163 Mouse 29 Nidoran??? 4 70 59 Poison Pin 30 Nidorina 8 200 117 Poison Pin 30 rows selected. SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CONTINENTS LIST MODELS CAMPUSES CARMAKERS COUNTRIES MAKES CARDATA ST SHARKS AIRPORTS MARATHON FACULTY DISCENR DISCIPLINES ENROLLMENTS DEGREES FEES FLIGHTS AIRLINES TEACHERS LEAGUES ATTENDANCE T ST01 NOPKEY PK ROOMS CUSTOMERS MINEFIELD RECEIPTS TABLE_NAME ------------------------------ ITEMS FOO1 BEERS MYBOOKS BEERS1 FOO2 FOO3 FOO4 FOO5 BARS DRINKS BEERS2 LIKETEST TIMES CHECKIN FOOBAR ATT2007 SEARCH KODIE CNTR ATTN LOCATIONS STUFF VECTORPAIRS VECTORS FST AGGS PTS MYLIST ALLELES MYVECTORS TABLE_NAME ------------------------------ POK PNEXT CC SPECIES ATTRIBUTES TYPES ANEW POKEMON EVOLUTION REACTORS PFIRST PPK 74 rows selected. SQL> select * from beers; NAME BREWERY TYPE ------------------------------ -------------------------------------------------- -------------------- Guinness Guinness stout Pale Ale Sierra Nevada Zhiguli lager Knights Valley California L'Apres-Midi SQL> select count(*) from reactors; COUNT(*) ---------- 37960 SQL> describe reactors Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- REPORTDT NOT NULL DATE UNIT NOT NULL VARCHAR2(64) POWER NUMBER(38) SQL> select count(distinct unit) from reactors; COUNT(DISTINCTUNIT) ------------------- 104 SQL> select unit, count(*) from 2 reactors 3 group by unit; UNIT COUNT(*) ---------------------------------------------------------------- ---------- Columbia Generating Station 365 Crystal River 3 365 Davis-Besse 365 Duane Arnold 365 Millstone 2 365 Nine Mile Point 1 365 North Anna 2 365 Palo Verde 1 365 Quad Cities 2 365 Surry 2 365 Vermont Yankee 365 Browns Ferry 3 365 FitzPatrick 365 Hatch 1 365 Monticello 365 Saint Lucie 2 365 San Onofre 3 365 Waterford 3 365 Wolf Creek 1 365 Braidwood 1 365 Braidwood 2 365 Browns Ferry 2 365 Callaway 365 Catawba 1 365 Clinton 365 Cooper 365 D.C. Cook 2 365 Diablo Canyon 1 365 Diablo Canyon 2 365 Fermi 2 365 Hope Creek 1 365 UNIT COUNT(*) ---------------------------------------------------------------- ---------- Oconee 2 365 Summer 365 Susquehanna 1 365 Vogtle 2 365 Browns Ferry 1 365 Catawba 2 365 D.C. Cook 1 365 La Salle 1 365 Limerick 2 365 Millstone 3 365 Nine Mile Point 2 365 Oconee 3 365 Robinson 2 365 Sequoyah 2 365 Watts Bar 1 365 Arkansas Nuclear 1 365 Beaver Valley 1 365 Byron 1 365 Dresden 2 365 Harris 1 365 Indian Point 2 365 La Salle 2 365 Limerick 1 365 Peach Bottom 2 365 Pilgrim 1 365 Prairie Island 1 365 Quad Cities 1 365 Saint Lucie 1 365 San Onofre 2 365 South Texas 2 365 Surry 1 365 UNIT COUNT(*) ---------------------------------------------------------------- ---------- Susquehanna 2 365 Turkey Point 4 365 Brunswick 1 365 Brunswick 2 365 Calvert Cliffs 2 365 Comanche Peak 2 365 Farley 2 365 Hatch 2 365 Indian Point 3 365 McGuire 1 365 Oyster Creek 365 Palo Verde 3 365 Perry 1 365 Prairie Island 2 365 Seabrook 1 365 South Texas 1 365 Byron 2 365 Dresden 3 365 Farley 1 365 Fort Calhoun 365 Ginna 365 Grand Gulf 1 365 Kewaunee 365 North Anna 1 365 Palisades 365 Point Beach 1 365 Point Beach 2 365 River Bend 1 365 Salem 1 365 Salem 2 365 Turkey Point 3 365 UNIT COUNT(*) ---------------------------------------------------------------- ---------- Arkansas Nuclear 2 365 Beaver Valley 2 365 Calvert Cliffs 1 365 Comanche Peak 1 365 McGuire 2 365 Oconee 1 365 Palo Verde 2 365 Peach Bottom 3 365 Sequoyah 1 365 Three Mile Island 1 365 Vogtle 1 365 104 rows selected. SQL> exit