SQL> select * from attributes where experience > 200; select * from attributes where experience > 200 * ERROR at line 1: ORA-00904: "EXPERIENCE": invalid identifier SQL> select * from attributes 2 where baseexperience > 200; POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 3 20 1000 208 6 17 905 209 9 16 855 210 59 19 1550 213 73 16 550 205 91 15 1325 203 99 13 600 206 103 20 1200 212 112 19 1200 204 113 11 346 255 121 11 800 207 128 14 884 211 130 65 2350 214 131 25 2200 219 142 18 590 202 144 17 554 215 145 16 526 216 146 20 600 217 149 22 2100 218 150 20 1220 220 154 18 1005 208 157 17 795 209 160 23 888 210 169 18 750 204 229 14 350 204 230 18 1520 207 242 15 468 255 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 243 19 1780 216 244 21 1980 217 245 20 1870 215 248 20 2020 218 249 52 2160 220 250 38 1990 220 254 17 522 208 257 19 520 209 260 15 819 210 282 16 484 208 289 20 1305 210 306 21 3600 205 321 145 3980 206 350 62 1620 213 373 15 1026 218 376 16 5500 210 377 17 2300 217 378 18 1750 216 379 19 2050 215 380 14 400 211 381 20 600 211 382 45 3520 218 383 35 9500 218 384 70 2065 220 385 3 11 215 386 17 608 215 389 22 3100 208 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 392 12 550 209 395 17 845 210 407 9 145 204 426 12 150 204 435 10 380 209 440 6 244 255 445 19 950 218 448 12 540 204 452 13 615 204 460 22 1355 214 462 12 1800 211 464 24 2828 217 465 20 1286 211 468 15 380 220 473 25 2910 207 475 16 520 208 477 22 1066 210 480 3 3 210 481 3 3 210 482 3 3 210 483 54 6830 220 484 42 3360 220 485 17 4300 215 486 37 4200 220 487 45 7500 220 488 15 856 210 490 3 14 215 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 491 15 505 210 493 32 3200 255 494 4 40 270 497 33 630 238 500 16 1500 238 503 15 946 238 508 12 610 221 521 12 290 215 526 17 2600 227 531 11 310 390 534 14 870 227 537 15 620 225 542 12 205 221 545 25 2005 214 553 15 963 229 576 15 440 221 579 10 201 221 584 13 575 241 601 6 810 234 604 21 805 232 609 10 343 234 612 18 1055 243 635 18 1600 270 637 16 460 248 638 21 2500 261 639 19 2600 261 640 20 2000 261 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 641 15 630 261 642 15 610 261 643 32 3300 306 644 29 3450 306 645 15 680 270 646 30 3250 297 647 14 485 261 648 6 65 270 649 15 825 270 117 rows selected. SQL> clear scr SQL> SELECT * 2 FROM Pokemon p, Attributes a 3 WHERE p.pokedexid = a.pokedexid AND a.baseexperience > 250 4 ORDER BY a.baseexperience 5 ; POKEDEXID NAME POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- ---------- -------------- 113 Chansey 113 11 346 255 242 Blissey 242 15 468 255 440 Happiny 440 6 244 255 493 Arceus 493 32 3200 255 640 Virizion 640 20 2000 261 647 Keldeo 647 14 485 261 642 Thundurus 642 15 610 261 641 Tornadus 641 15 630 261 639 Terrakion 639 19 2600 261 638 Cobalion 638 21 2500 261 645 Landorus 645 15 680 270 635 Hydreigon 635 18 1600 270 494 Victini 494 4 40 270 649 Genesect 649 15 825 270 648 Meloetta 648 6 65 270 646 Kyurem 646 30 3250 297 644 Zekrom 644 29 3450 306 643 Reshiram 643 32 3300 306 531 Audino 531 11 310 390 19 rows selected. SQL> select * from species; POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 1 12 Seed 2 12 Seed 3 12 Seed 4 10 Lizard 5 10 Flame 6 10 Flame 7 11 Tiny Turtle 8 11 Turtle 9 11 Shellfish 10 7 Worm 11 7 Cocoon 12 7 Butterfly 13 7 Hairy Bug 14 7 Cocoon 15 7 Poison Bee 16 1 Tiny Bird 17 1 Bird 18 1 Bird 19 1 Mouse 20 1 Mouse 21 1 Tiny Bird 22 1 Beak 23 4 Snake 24 4 Cobra 25 13 Mouse 26 13 Mouse 27 5 Mouse POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 28 5 Mouse 29 4 Poison Pin 30 4 Poison Pin 31 4 Drill 33 4 Poison Pin 34 4 Drill 35 1 Fairy 36 1 Fairy 37 10 Fox 38 10 Fox 39 1 Balloon 40 1 Balloon 41 4 Bat 42 4 Bat 43 12 Weed 44 12 Weed 45 12 Flower 46 7 Mushroom 47 7 Mushroom 48 7 Insect 49 7 Poison Moth 50 5 Mole 51 5 Mole 52 1 Scratch Cat 53 1 Classy Cat 54 11 Duck 55 11 Duck POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 56 2 Pig Monkey 57 2 Pig Monkey 58 10 Puppy 59 10 Legendary 60 11 Tadpole 61 11 Tadpole 62 11 Tadpole 63 14 Psi 64 14 Psi 65 14 Psi 66 2 Superpower 67 2 Superpower 68 2 Superpower 69 12 Flower 70 12 Flycatcher 71 12 Flycatcher 72 11 Jellyfish 73 11 Jellyfish 74 6 Rock 75 6 Rock 76 6 Megaton 77 10 Fire Horse 78 10 Fire Horse 79 11 Dopey 80 11 Hermit Crab 81 13 Magnet 82 13 Magnet POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 84 1 Twin Bird 85 1 Triple Bird 86 11 Sea Lion 87 11 Sea Lion 88 4 Sludge 89 4 Sludge 90 11 Bivalve 91 11 Bivalve 92 8 Gas 93 8 Gas 94 8 Shadow 95 6 Rock Snake 96 14 Hypnosis 97 14 Hypnosis 98 11 River Crab 99 11 Pincer 100 13 Ball 101 13 Ball 102 12 Egg 103 12 Coconut 104 5 Lonely 105 5 Bone Keeper 106 2 Kicking 107 2 Punching 108 1 Licking 109 4 Poison Gas 110 4 Poison Gas POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 111 5 Spikes 112 5 Drill 113 1 Egg 114 12 Vine 115 1 Parent 116 11 Dragon 117 11 Dragon 118 11 Goldfish 119 11 Goldfish 120 11 Star Shape 121 11 Mysterious 122 14 Barrier 123 7 Mantis 124 15 Human Shape 125 13 Electric 126 10 Spitfire 127 7 Stag Beetle 128 1 Wild Bull 129 11 Fish 130 11 Atrocious 131 11 Transport 132 1 Transform 133 1 Evolution 134 11 Bubble Jet 135 13 Lightning 136 10 Flame 137 1 Virtual POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 138 6 Spiral 139 6 Spiral 140 6 Shellfish 141 6 Shellfish 142 6 Fossil 143 1 Sleeping 144 15 Freeze 145 13 Electric 146 10 Flame 147 16 Dragon 148 16 Dragon 149 16 Dragon 150 14 Genetic 151 14 New Species 152 12 Leaf 153 12 Leaf 154 12 Herb 155 10 Fire Mouse 156 10 Volcano 157 10 Volcano 158 11 Big Jaw 159 11 Big Jaw 160 11 Big Jaw 161 1 Scout 162 1 Long Body 163 1 Owl 164 1 Owl POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 165 7 Five Star 166 7 Five Star 167 7 String Spit 168 7 Long Leg 169 4 Bat 170 11 Angler 171 11 Light 172 13 Tiny Mouse 173 1 Star Shape 174 1 Balloon 175 1 Spike Ball 176 1 Happiness 177 14 Tiny Bird 178 14 Mystic 179 13 Wool 180 13 Wool 181 13 Light 182 12 Flower 183 11 Aqua Mouse 184 11 Aqua Rabbit 185 6 Imitation 186 11 Frog 187 12 Cottonweed 188 12 Cottonweed 189 12 Cottonweed 190 1 Long Tail 191 12 Seed POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 192 12 Sun 193 7 Clear Wing 194 11 Water Fish 195 11 Water Fish 196 14 Sun 197 17 Moonlight 198 17 Darkness 199 11 Royal 200 8 Screech 201 14 Symbol 202 14 Patient 203 1 Long Neck 204 7 Bagworm 205 7 Bagworm 206 1 Land Snake 207 5 FlyScorpion 208 9 Iron Snake 209 1 Fairy 210 1 Fairy 211 11 Balloon 212 7 Pincer 213 7 Mold 214 7 Single Horn 215 17 Sharp Claw 216 1 Little Bear 217 1 Hibernator 218 10 Lava POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 219 10 Lava 220 15 Pig 221 15 Swine 222 11 Coral 223 11 Jet 224 11 Jet 225 15 Delivery 226 11 Kite 227 9 Armor Bird 228 17 Dark 229 17 Dark 230 11 Dragon 231 5 Long Nose 232 5 Armor 233 1 Virtual 234 1 Big Horn 235 1 Painter 236 2 Scuffle 237 2 Handstand 238 15 Kiss 239 13 Electric 240 10 Live Coal 241 1 Milk Cow 242 1 Happiness 243 13 Thunder 244 10 Volcano 245 11 Aurora POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 246 6 Rock Skin 247 6 Hard Shell 248 6 Armor 249 14 Diving 250 10 Rainbow 251 14 Time Travel 252 12 Wood Gecko 253 12 Wood Gecko 254 12 Forest 255 10 Chick 256 10 Young Fowl 257 10 Blaze 258 11 Mud Fish 259 11 Mud Fish 260 11 Mud Fish 261 17 Bite 262 17 Bite 263 1 TinyRaccoon 264 1 Rushing 265 7 Worm 266 7 Cocoon 267 7 Butterfly 268 7 Cocoon 269 7 Poison Moth 270 11 Water Weed 271 11 Jolly 272 11 Carefree POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 273 12 Acorn 274 12 Wily 275 12 Wicked 276 1 TinySwallow 277 1 Swallow 278 11 Seagull 279 11 Water Bird 280 14 Feeling 281 14 Emotion 282 14 Embrace 283 7 Pond Skater 284 7 Eyeball 285 12 Mushroom 286 12 Mushroom 287 1 Slacker 288 1 Wild Monkey 289 1 Lazy 290 7 Trainee 291 7 Ninja 292 7 Shed 293 1 Whisper 294 1 Big Voice 295 1 Loud Noise 296 2 Guts 297 2 Arm Thrust 298 1 Polka Dot 299 6 Compass POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 300 1 Kitten 301 1 Prim 302 17 Darkness 303 9 Deceiver 304 9 Iron Armor 305 9 Iron Armor 306 9 Iron Armor 307 2 Meditate 308 2 Meditate 309 13 Lightning 310 13 Discharge 311 13 Cheering 312 13 Cheering 313 7 Firefly 314 7 Firefly 315 12 Thorn 316 4 Stomach 317 4 Poison Bag 318 11 Savage 319 11 Brutal 320 11 Ball Whale 321 11 Float Whale 322 10 Numb 323 10 Eruption 324 10 Coal 325 14 Bounce 326 14 Manipulate POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 327 1 Spot Panda 328 5 Ant Pit 329 5 Vibration 330 5 Mystic 331 12 Cactus 332 12 Scarecrow 333 1 Cotton Bird 334 16 Humming 335 1 Cat Ferret 336 4 Fang Snake 337 6 Meteorite 338 6 Meteorite 339 11 Whiskers 340 11 Whiskers 341 11 Ruffian 342 11 Rogue 343 5 Clay Doll 344 5 Clay Doll 345 6 Sea Lily 346 6 Barnacle 347 6 Old Shrimp 348 6 Plate 349 11 Fish 350 11 Tender 351 1 Weather 352 1 Color Swap 353 8 Puppet POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 354 8 Marionette 355 8 Requiem 356 8 Beckon 357 12 Fruit 358 14 Wind Chime 359 17 Disaster 360 14 Bright 361 15 Snow Hat 362 15 Face 363 15 Clap 364 15 Ball Roll 365 15 Ice Break 366 11 Bivalve 367 11 Deep Sea 368 11 South Sea 369 11 Longevity 370 11 Rendezvous 371 16 Rock Head 372 16 Endurance 373 16 Dragon 374 9 Iron Ball 375 9 Iron Claw 376 9 Iron Leg 377 6 Rock Peak 378 15 Iceberg 379 9 Iron 380 16 Eon POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 381 16 Eon 382 11 Sea Basin 383 5 Continent 384 16 Sky High 385 9 Wish 386 14 DNA 387 12 Tiny Leaf 388 12 Grove 389 12 Continent 390 10 Chimp 391 10 Playful 392 10 Flame 393 11 Penguin 394 11 Penguin 395 11 Emperor 396 1 Starling 397 1 Starling 398 1 Predator 399 1 Plump Mouse 400 1 Beaver 401 7 Cricket 402 7 Cricket 403 13 Flash 404 13 Spark 405 13 Gleam Eyes 406 12 Bud 407 12 Bouquet POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 408 6 Head Butt 409 6 Head Butt 410 6 Shield 411 6 Shield 412 7 Bagworm 413 7 Bagworm 414 7 Moth 415 7 Tiny Bee 416 7 Beehive 417 13 EleSquirrel 418 11 Sea Weasel 419 11 Sea Weasel 420 12 Cherry 421 12 Blossom 422 11 Sea Slug 423 11 Sea Slug 424 1 Long Tail 425 8 Balloon 426 8 Blimp 427 1 Rabbit 428 1 Rabbit 429 8 Magical 430 17 Big Boss 431 1 Catty 432 1 Tiger Cat 433 14 Bell 434 4 Skunk POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 435 4 Skunk 436 9 Bronze 437 9 Bronze Bell 438 6 Bonsai 439 14 Mime 440 1 Playhouse 441 1 Music Note 442 8 Forbidden 443 16 Land Shark 444 16 Cave 445 16 Mach 446 1 Big Eater 447 2 Emanation 448 2 Aura 449 5 Hippo 450 5 Heavyweight 451 4 Scorpion 452 4 Ogre Scorp 453 4 Toxic Mouth 454 4 Toxic Mouth 455 12 Bug Catcher 456 11 Wing Fish 457 11 Neon 458 11 Kite 459 12 Frost Tree 460 12 Frost Tree 461 17 Sharp Claw POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 462 13 Magnet Area 463 1 Licking 464 5 Drill 465 12 Vine 466 13 Thunderbolt 467 10 Blast 468 1 Jubilee 469 7 Ogre Darner 470 12 Verdant 471 15 Fresh Snow 472 5 Fang Scorp 473 15 Twin Tusk 474 1 Virtual 475 14 Blade 476 6 Compass 477 8 Gripper 478 15 Snow Land 479 13 Plasma 480 14 Knowledge 481 14 Emotion 482 14 Willpower 483 9 Temporal 484 11 Spatial 485 10 Lava Dome 486 1 Colossal 487 8 Renegade 488 14 Lunar POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 489 11 Sea Drifter 490 11 Seafaring 491 17 Pitch-Black 492 12 Gratitude 493 1 Alpha 494 14 Victory 495 12 Grass Snake 496 12 Grass Snake 497 12 Regal 498 10 Fire Pig 499 10 Fire Pig 500 10 Mega Fire Pig 501 11 Sea Otter 502 11 Discipline 503 11 Formidable 504 1 Scout 505 1 Lookout 506 1 Puppy 507 1 Loyal Dog 508 1 Big-Hearted 509 17 Devious 510 17 Cruel 511 12 Grass Monkey 512 12 Thorn Monkey 513 10 High Temp 514 10 Ember 515 11 Spray POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 516 11 Geyser 517 14 Dream Eater 518 14 Drowsing 519 1 Tiny Pigeon 520 1 Wild Pigeon 521 1 Proud 522 13 Electrified 523 13 Thunderbolt 524 6 Mantle 525 6 Ore 526 6 Compressed 527 14 Bat 528 14 Courting 529 5 Mole 530 5 Subterrene 531 1 Hearing 532 2 Muscular 533 2 Muscular 534 2 Muscular 535 11 Tadpole 536 11 Vibration 537 11 Vibration 538 2 Judo 539 2 Karate 540 7 Sewing 541 7 Leaf-Wrapped 542 7 Nurturing POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 543 7 Centipede 544 7 Curlipede 545 7 Megapede 546 12 Cotton Puff 547 12 Windveiled 548 12 Bulb 549 12 Flowering 550 11 Hostile 551 5 Desert Croc 552 5 Desert Croc 553 5 Intimidation 554 10 Zen Charm 555 10 Blazing 556 12 Cactus 557 7 Rock Inn 558 7 Stone Home 559 17 Shedding 560 17 Hoodlum 561 14 Avianoid 562 8 Spirit 563 8 Coffin 564 11 Prototurtle 565 11 Prototurtle 566 6 First Bird 567 6 First Bird 568 4 Trash Bag 569 4 Trash Heap POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 570 17 Tricky Fox 571 17 Illusion Fox 572 1 Chinchilla 573 1 Scarf 574 14 Fixation 575 14 Manipulate 576 14 Astral Body 577 14 Cell 578 14 Mitosis 579 14 Multiplying 580 11 Water Bird 581 11 White Bird 582 15 Fresh Snow 583 15 Icy Snow 584 15 Snowstorm 585 1 Season 586 1 Season 587 13 Sky Squirrel 588 7 Clamping 589 7 Cavalry 590 12 Mushroom 591 12 Mushroom 592 11 Floating 593 11 Floating 594 11 Caring 595 7 Attaching 596 7 EleSpider POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 597 12 Thorn Seed 598 12 Thorn Pod 599 9 Gear 600 9 Gear 601 9 Gear 602 13 EleFish 603 13 EleFish 604 13 EleFish 605 14 Cerebral 606 14 Cerebral 607 8 Candle 608 8 Lamp 609 8 Luring 610 16 Tusk 611 16 Axe Jaw 612 16 Axe Jaw 613 15 Chill 614 15 Freezing 615 15 Crystallizing 616 7 Snail 617 7 Shell Out 618 5 Trap 619 2 Martial Arts 620 2 Martial Arts 621 16 Cave 622 5 Automaton 623 5 Automaton POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 624 17 Sharp Blade 625 17 Sword Blade 626 1 Bash Buffalo 627 1 Eaglet 628 1 Valiant 629 17 Diapered 630 17 Bone Vulture 631 10 Anteater 632 7 Iron Ant 633 17 Irate 634 17 Hostile 635 17 Brutal 636 7 Torch 637 7 Sun 638 9 Iron Will 639 6 Cavern 640 12 Grassland 641 3 Cyclone 642 13 Bolt Strike 643 16 Vast White 644 16 Deep Black 645 5 Abundance 646 16 Boundary 647 11 Colt 648 1 Melody 649 7 Paleozoic 1000 14 Database 648 rows selected. SQL> select * from attributes; POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 1 7 69 64 2 10 130 141 3 20 1000 208 4 6 85 65 5 11 190 142 6 17 905 209 7 5 90 66 8 10 225 143 9 16 855 210 10 3 29 53 11 7 99 72 12 11 320 160 13 3 32 52 14 6 100 71 15 10 295 159 16 3 18 55 17 11 300 113 18 15 395 172 19 3 35 57 20 7 185 116 21 3 20 58 22 12 380 162 23 20 69 62 24 35 650 147 25 4 60 82 26 8 300 122 27 6 120 93 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 28 10 295 163 29 4 70 59 30 8 200 117 31 13 600 194 33 9 195 118 34 14 620 195 35 6 75 68 36 13 400 129 37 6 99 63 38 11 199 178 39 5 55 76 40 10 120 109 41 8 75 54 42 16 550 171 43 5 54 78 44 8 86 132 45 12 186 184 46 3 54 70 47 10 295 128 48 10 300 75 49 15 125 138 50 2 8 81 51 7 333 153 52 4 42 69 53 10 320 148 54 8 196 80 55 17 766 174 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 56 5 280 74 57 10 320 149 58 7 190 91 59 19 1550 213 60 6 124 77 61 10 200 131 62 13 540 185 63 9 195 75 64 13 565 145 65 15 480 186 66 8 195 75 67 15 705 146 68 16 1300 193 69 7 40 84 70 10 64 151 71 17 155 191 72 9 455 105 73 16 550 205 74 4 200 73 75 10 1050 134 76 14 3000 177 77 10 300 152 78 17 950 192 79 12 360 99 80 16 785 164 81 3 60 89 82 10 600 161 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 84 14 392 96 85 18 852 158 86 11 900 100 87 17 1200 176 88 9 300 90 89 12 300 157 90 3 40 97 91 15 1325 203 92 13 1 95 93 16 1 126 94 15 405 190 95 88 2100 108 96 10 324 102 97 16 756 165 98 4 65 115 99 13 600 206 100 5 104 103 101 12 666 150 102 4 25 98 103 20 1200 212 104 4 65 87 105 10 450 124 106 15 498 139 107 14 502 140 108 12 655 127 109 6 10 114 110 12 95 173 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 111 10 1150 135 112 19 1200 204 113 11 346 255 114 10 350 166 115 22 800 175 116 4 80 83 117 12 250 155 118 6 150 111 119 13 390 170 120 8 345 106 121 11 800 207 122 13 545 136 123 15 560 187 124 14 406 137 125 11 300 156 126 13 445 167 127 15 550 200 128 14 884 211 129 9 100 20 130 65 2350 214 131 25 2200 219 132 3 40 61 133 3 65 92 134 10 290 196 135 8 245 197 136 9 250 198 137 8 365 130 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 138 4 75 99 139 10 350 199 140 5 115 99 141 13 405 199 142 18 590 202 143 21 4600 154 144 17 554 215 145 16 526 216 146 20 600 217 147 18 33 67 148 40 165 144 149 22 2100 218 150 20 1220 220 151 4 40 64 152 9 64 64 153 12 158 141 154 18 1005 208 155 5 79 65 156 9 190 142 157 17 795 209 158 6 95 66 159 11 250 143 160 23 888 210 161 8 60 57 162 18 325 116 163 7 212 58 164 16 408 162 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 165 10 108 54 166 14 356 134 167 5 85 54 168 11 335 134 169 18 750 204 170 5 120 90 171 12 225 156 172 3 20 42 173 3 30 37 174 3 10 39 175 3 15 74 176 6 32 114 177 2 20 73 178 15 150 171 179 6 78 59 180 8 133 117 181 14 615 194 182 4 58 184 183 4 85 58 184 8 285 153 185 12 380 135 186 11 339 185 187 4 5 74 188 6 10 136 189 8 30 176 190 8 115 94 191 3 18 52 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 192 8 85 146 193 12 380 147 194 4 85 52 195 14 750 137 196 9 265 197 197 10 270 197 198 5 21 107 199 20 795 164 200 7 10 147 201 5 50 61 202 13 285 177 203 15 415 149 204 6 72 60 205 12 1258 118 206 15 140 125 207 11 648 108 208 92 4000 196 209 6 78 63 210 14 487 178 211 5 39 100 212 18 1180 200 213 6 205 80 214 15 540 200 215 9 280 132 216 6 88 124 217 18 1258 189 218 7 350 78 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 219 8 550 154 220 4 65 78 221 11 558 160 222 6 50 113 223 6 120 78 224 9 285 164 225 9 160 183 226 21 2200 168 227 17 505 168 228 6 108 114 229 14 350 204 230 18 1520 207 231 5 335 124 232 11 1200 189 233 6 325 180 234 14 712 165 235 12 580 106 236 7 210 91 237 14 480 138 238 4 60 87 239 6 235 106 240 7 214 117 241 12 755 200 242 15 468 255 243 19 1780 216 244 21 1980 217 245 20 1870 215 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 246 6 720 67 247 12 1520 144 248 20 2020 218 249 52 2160 220 250 38 1990 220 251 6 50 64 252 5 50 65 253 9 216 141 254 17 522 208 255 4 25 65 256 9 195 142 257 19 520 209 258 4 76 65 259 7 280 143 260 15 819 210 261 5 136 55 262 10 370 128 263 4 175 60 264 5 325 128 265 3 36 54 266 6 100 72 267 10 284 161 268 7 115 72 269 12 316 161 270 5 26 74 271 12 325 141 272 15 550 181 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 273 5 40 74 274 10 280 141 275 13 596 181 276 3 23 59 277 7 198 162 278 6 95 64 279 12 280 164 280 4 66 70 281 8 202 140 282 16 484 208 283 5 17 63 284 8 36 128 285 4 45 65 286 12 392 165 287 8 240 83 288 14 465 126 289 20 1305 210 290 5 55 65 291 8 120 155 292 8 12 95 293 6 163 68 294 10 405 126 295 15 840 184 296 10 864 87 297 23 2538 184 298 2 20 33 299 10 970 108 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 300 6 110 65 301 11 326 138 302 5 110 98 303 6 115 98 304 4 600 96 305 9 1200 152 306 21 3600 205 307 6 112 91 308 13 315 153 309 6 152 104 310 15 402 168 311 4 42 120 312 4 42 120 313 7 177 146 314 6 177 146 315 3 20 152 316 4 103 75 317 17 800 168 318 8 208 88 319 18 888 175 320 20 1300 137 321 145 3980 206 322 7 240 88 323 19 2200 175 324 5 804 161 325 7 306 89 326 9 715 164 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 327 11 50 85 328 7 150 73 329 11 153 126 330 20 820 197 331 4 513 97 332 13 774 177 333 4 12 74 334 11 206 188 335 13 403 165 336 27 525 165 337 10 1680 150 338 12 1540 150 339 4 19 92 340 9 236 158 341 6 115 111 342 11 328 161 343 5 215 58 344 15 1080 189 345 10 238 99 346 15 604 199 347 7 125 99 348 15 682 199 349 6 74 61 350 62 1620 213 351 3 8 145 352 10 220 132 353 6 23 97 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 354 11 125 179 355 8 150 97 356 16 306 179 357 20 1000 169 358 6 10 147 359 12 470 174 360 6 140 44 361 7 168 74 362 15 2565 187 363 8 395 75 364 11 876 128 365 14 1506 192 366 4 525 142 367 17 270 178 368 18 226 178 369 10 234 198 370 6 87 110 371 6 421 89 372 11 1105 144 373 15 1026 218 374 6 952 103 375 12 2025 153 376 16 5500 210 377 17 2300 217 378 18 1750 216 379 19 2050 215 380 14 400 211 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 381 20 600 211 382 45 3520 218 383 35 9500 218 384 70 2065 220 385 3 11 215 386 17 608 215 387 4 102 64 388 11 970 141 389 22 3100 208 390 5 62 65 391 9 220 142 392 12 550 209 393 4 52 66 394 8 230 143 395 17 845 210 396 3 20 56 397 6 155 113 398 12 249 172 399 5 200 58 400 10 315 116 401 3 22 54 402 10 255 159 403 5 95 60 404 9 305 117 405 14 420 194 406 2 12 68 407 9 145 204 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 408 9 315 99 409 16 1025 199 410 5 570 99 411 13 1495 199 412 2 34 61 413 5 65 159 414 9 233 159 415 3 55 63 416 12 385 188 417 4 39 120 418 7 295 75 419 11 335 178 420 4 33 68 421 5 93 133 422 3 63 73 423 9 299 176 424 12 203 186 425 4 12 127 426 12 150 204 427 4 55 84 428 12 333 178 429 9 44 187 430 9 273 187 431 5 39 71 432 10 438 183 433 2 6 74 434 4 192 79 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 435 10 380 209 436 5 605 72 437 13 1870 188 438 5 150 68 439 6 130 78 440 6 244 255 441 5 19 107 442 10 1080 168 443 7 205 67 444 14 560 144 445 19 950 218 446 6 1050 94 447 7 202 72 448 12 540 204 449 8 495 95 450 20 3000 198 451 8 120 114 452 13 615 204 453 7 230 83 454 13 444 181 455 14 270 164 456 4 70 90 457 12 240 156 458 10 650 108 459 10 505 131 460 22 1355 214 461 11 340 199 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 462 12 1800 211 463 17 1400 193 464 24 2828 217 465 20 1286 211 466 18 1386 199 467 16 680 199 468 15 380 220 469 19 515 198 470 10 255 196 471 8 259 196 472 20 425 192 473 25 2910 207 474 9 340 185 475 16 520 208 476 14 3400 198 477 22 1066 210 478 13 266 187 479 3 3 132 480 3 3 210 481 3 3 210 482 3 3 210 483 54 6830 220 484 42 3360 220 485 17 4300 215 486 37 4200 220 487 45 7500 220 488 15 856 210 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 489 4 31 165 490 3 14 215 491 15 505 210 492 2 21 64 493 32 3200 255 494 4 40 270 495 6 81 28 496 8 160 145 497 33 630 238 498 5 99 28 499 10 555 146 500 16 1500 238 501 5 59 28 502 8 245 145 503 15 946 238 504 5 116 51 505 11 270 147 506 4 41 55 507 9 147 130 508 12 610 221 509 4 101 56 510 11 375 156 511 6 105 63 512 11 305 174 513 6 110 63 514 10 280 174 515 6 135 63 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 516 10 290 174 517 6 233 58 518 11 605 170 519 3 21 53 520 6 150 125 521 12 290 215 522 8 298 59 523 16 795 174 524 4 180 56 525 9 1020 137 526 17 2600 227 527 4 21 63 528 9 105 149 529 3 85 66 530 7 404 178 531 11 310 390 532 6 125 61 533 12 400 142 534 14 870 227 535 5 45 59 536 8 170 134 537 15 620 225 538 13 555 163 539 14 510 163 540 3 25 62 541 5 73 133 542 12 205 221 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 543 4 53 52 544 12 585 126 545 25 2005 214 546 3 6 56 547 7 66 168 548 5 66 56 549 11 163 168 550 10 180 161 551 7 152 58 552 10 334 123 553 15 963 229 554 6 375 63 555 13 929 168 556 10 280 161 557 3 145 65 558 14 2000 166 559 6 118 70 560 11 300 171 561 14 140 172 562 5 15 61 563 17 765 169 564 7 165 71 565 12 810 173 566 5 95 71 567 14 320 177 568 6 310 66 569 19 1073 166 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 570 7 125 66 571 16 811 179 572 4 58 60 573 5 75 165 574 4 58 58 575 7 180 137 576 15 440 221 577 3 10 58 578 6 80 130 579 10 201 221 580 5 55 61 581 13 242 166 582 4 57 61 583 11 410 138 584 13 575 241 585 6 195 67 586 19 925 166 587 4 50 150 588 5 59 63 589 10 330 173 590 2 10 59 591 6 105 162 592 12 330 67 593 22 1350 168 594 12 316 165 595 1 6 64 596 8 143 165 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 597 6 188 61 598 10 1100 171 599 3 210 60 600 6 510 154 601 6 810 234 602 2 3 55 603 12 220 142 604 21 805 232 605 5 90 67 606 10 345 170 607 3 31 55 608 6 130 130 609 10 343 234 610 6 180 64 611 10 360 144 612 18 1055 243 613 5 85 61 614 26 2600 170 615 11 1480 170 616 4 77 61 617 8 253 173 618 7 110 165 619 9 200 70 620 14 355 179 621 16 1390 170 622 10 920 61 623 28 3300 169 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 624 5 102 68 625 16 700 172 626 16 946 172 627 5 105 70 628 15 410 179 629 5 90 74 630 12 395 179 631 14 580 169 632 3 330 169 633 8 173 60 634 14 500 147 635 18 1600 270 636 11 288 72 637 16 460 248 638 21 2500 261 639 19 2600 261 640 20 2000 261 641 15 630 261 642 15 610 261 643 32 3300 306 644 29 3450 306 645 15 680 270 646 30 3250 297 647 14 485 261 648 6 65 270 649 15 825 270 1000 8 300 200 648 rows selected. SQL> describe pokemon Name Null? Type ----------------------------------------------------- -------- ------------------------------------ POKEDEXID NOT NULL NUMBER(38) NAME VARCHAR2(20) SQL> describe species Name Null? Type ----------------------------------------------------- -------- ------------------------------------ POKEDEXID NOT NULL NUMBER(38) TYPEID NUMBER(38) GENUS VARCHAR2(20) SQL> SQL> SELECT p.pokedexid, p.name, a.height, a.weight, s.genus 2 FROM pokemon p, species s, attributes a 3 WHERE p.pokedexid = s.pokedexid AND 4 a.pokedexid = p.pokedexid AND 5 a.weight > 800 6 ; POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 3 Venusaur 20 1000 Seed 6 Charizard 17 905 Flame 9 Blastoise 16 855 Shellfish 59 Arcanine 19 1550 Legendary 68 Machamp 16 1300 Superpower 75 Graveler 10 1050 Rock 76 Golem 14 3000 Megaton 78 Rapidash 17 950 Fire Horse 85 Dodrio 18 852 Triple Bird 86 Seel 11 900 Sea Lion 87 Dewgong 17 1200 Sea Lion 91 Cloyster 15 1325 Bivalve 95 Onix 88 2100 Rock Snake 103 Exeggutor 20 1200 Coconut 111 Rhyhorn 10 1150 Spikes 112 Rhydon 19 1200 Drill 128 Tauros 14 884 Wild Bull 130 Gyarados 65 2350 Atrocious 131 Lapras 25 2200 Transport 143 Snorlax 21 4600 Sleeping 149 Dragonite 22 2100 Dragon 150 Mewtwo 20 1220 Genetic 154 Meganium 18 1005 Herb 160 Feraligatr 23 888 Big Jaw 205 Forretress 12 1258 Bagworm 208 Steelix 92 4000 Iron Snake 212 Scizor 18 1180 Pincer POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 217 Ursaring 18 1258 Hibernator 226 Mantine 21 2200 Kite 230 Kingdra 18 1520 Dragon 232 Donphan 11 1200 Armor 243 Raikou 19 1780 Thunder 244 Entei 21 1980 Volcano 245 Suicune 20 1870 Aurora 247 Pupitar 12 1520 Hard Shell 248 Tyranitar 20 2020 Armor 249 Lugia 52 2160 Diving 250 Ho-Oh 38 1990 Rainbow 260 Swampert 15 819 Mud Fish 289 Slaking 20 1305 Lazy 295 Exploud 15 840 Loud Noise 296 Makuhita 10 864 Guts 297 Hariyama 23 2538 Arm Thrust 299 Nosepass 10 970 Compass 305 Lairon 9 1200 Iron Armor 306 Aggron 21 3600 Iron Armor 319 Sharpedo 18 888 Brutal 320 Wailmer 20 1300 Ball Whale 321 Wailord 145 3980 Float Whale 323 Camerupt 19 2200 Eruption 324 Torkoal 5 804 Coal 330 Flygon 20 820 Mystic 337 Lunatone 10 1680 Meteorite 338 Solrock 12 1540 Meteorite POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 344 Claydol 15 1080 Clay Doll 350 Milotic 62 1620 Tender 357 Tropius 20 1000 Fruit 362 Glalie 15 2565 Face 364 Sealeo 11 876 Ball Roll 365 Walrein 14 1506 Ice Break 372 Shelgon 11 1105 Endurance 373 Salamence 15 1026 Dragon 374 Beldum 6 952 Iron Ball 375 Metang 12 2025 Iron Claw 376 Metagross 16 5500 Iron Leg 377 Regirock 17 2300 Rock Peak 378 Regice 18 1750 Iceberg 379 Registeel 19 2050 Iron 382 Kyogre 45 3520 Sea Basin 383 Groudon 35 9500 Continent 384 Rayquaza 70 2065 Sky High 388 Grotle 11 970 Grove 389 Torterra 22 3100 Continent 395 Empoleon 17 845 Emperor 409 Rampardos 16 1025 Head Butt 411 Bastiodon 13 1495 Shield 437 Bronzong 13 1870 Bronze Bell 442 Spiritomb 10 1080 Forbidden 445 Garchomp 19 950 Mach 446 Munchlax 6 1050 Big Eater 450 Hippowdon 20 3000 Heavyweight POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 460 Abomasnow 22 1355 Frost Tree 462 Magnezone 12 1800 Magnet Area 463 Lickilicky 17 1400 Licking 464 Rhyperior 24 2828 Drill 465 Tangrowth 20 1286 Vine 466 Electivire 18 1386 Thunderbolt 473 Mamoswine 25 2910 Twin Tusk 476 Probopass 14 3400 Compass 477 Dusknoir 22 1066 Gripper 483 Dialga 54 6830 Temporal 484 Palkia 42 3360 Spatial 485 Heatran 17 4300 Lava Dome 486 Regigigas 37 4200 Colossal 487 Giratina 45 7500 Renegade 488 Cresselia 15 856 Lunar 493 Arceus 32 3200 Alpha 500 Emboar 16 1500 Mega Fire Pig 503 Samurott 15 946 Formidable 525 Boldore 9 1020 Ore 526 Gigalith 17 2600 Compressed 534 Conkeldurr 14 870 Muscular 545 Scolipede 25 2005 Megapede 553 Krookodile 15 963 Intimidation 555 Darmanitan 13 929 Blazing 558 Crustle 14 2000 Stone Home 565 Carracosta 12 810 Prototurtle 569 Garbodor 19 1073 Trash Heap POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 571 Zoroark 16 811 Illusion Fox 586 Sawsbuck 19 925 Season 593 Jellicent 22 1350 Floating 598 Ferrothorn 10 1100 Thorn Pod 601 Klinklang 6 810 Gear 604 Eelektross 21 805 EleFish 612 Haxorus 18 1055 Axe Jaw 614 Beartic 26 2600 Freezing 615 Cryogonal 11 1480 Crystallizing 621 Druddigon 16 1390 Cave 622 Golett 10 920 Automaton 623 Golurk 28 3300 Automaton 626 Bouffalant 16 946 Bash Buffalo 635 Hydreigon 18 1600 Brutal 638 Cobalion 21 2500 Iron Will 639 Terrakion 19 2600 Cavern 640 Virizion 20 2000 Grassland 643 Reshiram 32 3300 Vast White 644 Zekrom 29 3450 Deep Black 646 Kyurem 30 3250 Boundary 649 Genesect 15 825 Paleozoic 129 rows selected. SQL> SQL> SELECT p.pokedexid, p.name, a.height, a.weight, s.genus 2 FROM pokemon p, species s, attributes a 3 WHERE p.pokedexid = s.pokedexid AND 4 a.pokedexid = p.pokedexid AND 5 a.weight > 1399 6 ; POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 59 Arcanine 19 1550 Legendary 76 Golem 14 3000 Megaton 95 Onix 88 2100 Rock Snake 130 Gyarados 65 2350 Atrocious 131 Lapras 25 2200 Transport 143 Snorlax 21 4600 Sleeping 149 Dragonite 22 2100 Dragon 208 Steelix 92 4000 Iron Snake 226 Mantine 21 2200 Kite 230 Kingdra 18 1520 Dragon 243 Raikou 19 1780 Thunder 244 Entei 21 1980 Volcano 245 Suicune 20 1870 Aurora 247 Pupitar 12 1520 Hard Shell 248 Tyranitar 20 2020 Armor 249 Lugia 52 2160 Diving 250 Ho-Oh 38 1990 Rainbow 297 Hariyama 23 2538 Arm Thrust 306 Aggron 21 3600 Iron Armor 321 Wailord 145 3980 Float Whale 323 Camerupt 19 2200 Eruption 337 Lunatone 10 1680 Meteorite 338 Solrock 12 1540 Meteorite 350 Milotic 62 1620 Tender 362 Glalie 15 2565 Face 365 Walrein 14 1506 Ice Break 375 Metang 12 2025 Iron Claw POKEDEXID NAME HEIGHT WEIGHT GENUS ---------- -------------------- ---------- ---------- -------------------- 376 Metagross 16 5500 Iron Leg 377 Regirock 17 2300 Rock Peak 378 Regice 18 1750 Iceberg 379 Registeel 19 2050 Iron