mysql> select name from PokeData where weight < (select Weight from PokeData where name = 'Pikachu'); +------------+ | name | +------------+ | Litwick | | Tynamo | | Joltik | | Foongus | | Karrablast | | Emolga | | Vanillite | | Ducklett | | Solosis | | Gothita | | Minccino | | Yamask | | Cottonee | | Venipede | | Sewaddle | | Tympole | | Woobat | | Pidove | | Lillipup | | Oshawott | | Victini | | Shaymin | | Manaphy | | Phione | | Azelf | | Mesprit | | Uxie | | Rotom | | Chatot | | Chingling | | Glameow | | Mismagius | | Buneary | | Drifloon | | Cherubi | | Pachirisu | | Combee | | Burmy | | Budew | | Kricketot | | Starly | | Piplup | | Jirachi | | Chimecho | | Shuppet | | Castform | | Barboach | | Swablu | | Spinda | | Roselia | | Minun | | Plusle | | Azurill | | Shedinja | | Nincada | | Shroomish | | Masquerain | | Surskit | | Taillow | | Seedot | | Lotad | | Wurmple | | Torchic | | Treecko | | Celebi | | Corsola | | Qwilfish | | Unown | | Misdreavus | | Murkrow | | Sunkern | | Jumpluff | | Skiploom | | Hoppip | | Bellossom | | Natu | | Togetic | | Togepi | | Igglybuff | | Cleffa | | Pichu | | Mew | | Dratini | | Ditto | | Koffing | | Exeggcute | | Haunter | | Gastly | | Shellder | | Bellsprout | | Meowth | | Diglett | | Paras | | Oddish | | Jigglypuff | | Spearow | | Rattata | | Pidgey | | Weedle | | Caterpie | +------------+ 100 rows in set (0.00 sec) mysql> select name from PokeData where weight < (select Weight from PokeData where name = 'Pikachu')/2; +------------+ | name | +------------+ | Tynamo | | Joltik | | Foongus | | Solosis | | Yamask | | Cottonee | | Sewaddle | | Woobat | | Pidove | | Shaymin | | Manaphy | | Azelf | | Mesprit | | Uxie | | Rotom | | Chatot | | Chingling | | Drifloon | | Budew | | Kricketot | | Starly | | Jirachi | | Chimecho | | Shuppet | | Castform | | Barboach | | Swablu | | Roselia | | Azurill | | Shedinja | | Surskit | | Taillow | | Lotad | | Torchic | | Misdreavus | | Murkrow | | Sunkern | | Skiploom | | Hoppip | | Natu | | Togepi | | Igglybuff | | Pichu | | Koffing | | Exeggcute | | Haunter | | Gastly | | Diglett | | Spearow | | Pidgey | | Caterpie | +------------+ 51 rows in set (0.01 sec) mysql> select * from PokeData d, PokeData p -> where p.Name = 'Pikachu' and d.weight < p.weight/2 -> ; +------------+-----------+--------+--------+----------------+-------------+----------+------+--------+---------+-----------+--------+--------+----------------+-------+----------+------+--------+ | Name | PokedexID | Height | Weight | BaseExperience | Genus | Type | gen | typeId | Name | PokedexID | Height | Weight | BaseExperience | Genus | Type | gen | typeId | +------------+-----------+--------+--------+----------------+-------------+----------+------+--------+---------+-----------+--------+--------+----------------+-------+----------+------+--------+ | Tynamo | 602 | 2 | 3 | 55 | EleFish | electric | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Joltik | 595 | 1 | 6 | 64 | Attaching | bug | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Foongus | 590 | 2 | 10 | 59 | Mushroom | grass | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Solosis | 577 | 3 | 10 | 58 | Cell | psychic | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Yamask | 562 | 5 | 15 | 61 | Spirit | ghost | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Cottonee | 546 | 3 | 6 | 56 | Cotton Puff | grass | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Sewaddle | 540 | 3 | 25 | 62 | Sewing | bug | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Woobat | 527 | 4 | 21 | 63 | Bat | psychic | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Pidove | 519 | 3 | 21 | 53 | Tiny Pigeon | normal | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Shaymin | 492 | 2 | 21 | 64 | Gratitude | grass | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Manaphy | 490 | 3 | 14 | 215 | Seafaring | water | 4 | 1 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Azelf | 482 | 3 | 3 | 210 | Willpower | psychic | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Mesprit | 481 | 3 | 3 | 210 | Emotion | psychic | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Uxie | 480 | 3 | 3 | 210 | Knowledge | psychic | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Rotom | 479 | 3 | 3 | 132 | Plasma | electric | 4 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Chatot | 441 | 5 | 19 | 107 | Music Note | normal | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Chingling | 433 | 2 | 6 | 74 | Bell | psychic | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Drifloon | 425 | 4 | 12 | 127 | Balloon | ghost | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Budew | 406 | 2 | 12 | 68 | Bud | grass | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Kricketot | 401 | 3 | 22 | 54 | Cricket | bug | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Starly | 396 | 3 | 20 | 56 | Starling | normal | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Jirachi | 385 | 3 | 11 | 215 | Wish | steel | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Chimecho | 358 | 6 | 10 | 147 | Wind Chime | psychic | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Shuppet | 353 | 6 | 23 | 97 | Puppet | ghost | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Castform | 351 | 3 | 8 | 145 | Weather | normal | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Barboach | 339 | 4 | 19 | 92 | Whiskers | water | 3 | 1 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Swablu | 333 | 4 | 12 | 74 | Cotton Bird | normal | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Roselia | 315 | 3 | 20 | 152 | Thorn | grass | 3 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Azurill | 298 | 2 | 20 | 33 | Polka Dot | normal | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Shedinja | 292 | 8 | 12 | 95 | Shed | bug | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Surskit | 283 | 5 | 17 | 63 | Pond Skater | bug | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Taillow | 276 | 3 | 23 | 59 | TinySwallow | normal | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Lotad | 270 | 5 | 26 | 74 | Water Weed | water | 2 | 1 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Torchic | 255 | 4 | 25 | 65 | Chick | fire | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Misdreavus | 200 | 7 | 10 | 147 | Screech | ghost | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Murkrow | 198 | 5 | 21 | 107 | Darkness | dark | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Sunkern | 191 | 3 | 18 | 52 | Seed | grass | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Skiploom | 188 | 6 | 10 | 136 | Cottonweed | grass | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Hoppip | 187 | 4 | 5 | 74 | Cottonweed | grass | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Natu | 177 | 2 | 20 | 73 | Tiny Bird | psychic | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Togepi | 175 | 3 | 15 | 74 | Spike Ball | normal | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Igglybuff | 174 | 3 | 10 | 39 | Balloon | normal | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Pichu | 172 | 3 | 20 | 42 | Tiny Mouse | electric | 2 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Koffing | 109 | 6 | 10 | 114 | Poison Gas | poison | 1 | 2 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Exeggcute | 102 | 4 | 25 | 98 | Egg | grass | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Haunter | 93 | 16 | 1 | 126 | Gas | ghost | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Gastly | 92 | 13 | 1 | 95 | Gas | ghost | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Diglett | 50 | 2 | 8 | 81 | Mole | ground | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Spearow | 21 | 3 | 20 | 58 | Tiny Bird | normal | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Pidgey | 16 | 3 | 18 | 55 | Tiny Bird | normal | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | | Caterpie | 10 | 3 | 29 | 53 | Worm | bug | 1 | 0 | Pikachu | 25 | 4 | 60 | 82 | Mouse | electric | 1 | 0 | +------------+-----------+--------+--------+----------------+-------------+----------+------+--------+---------+-----------+--------+--------+----------------+-------+----------+------+--------+ 51 rows in set (0.01 sec) mysql> select d.name from PokeData d, PokeData p where p.Name = 'Pikachu' and d.weight < p.weight/2; +------------+ | name | +------------+ | Tynamo | | Joltik | | Foongus | | Solosis | | Yamask | | Cottonee | | Sewaddle | | Woobat | | Pidove | | Shaymin | | Manaphy | | Azelf | | Mesprit | | Uxie | | Rotom | | Chatot | | Chingling | | Drifloon | | Budew | | Kricketot | | Starly | | Jirachi | | Chimecho | | Shuppet | | Castform | | Barboach | | Swablu | | Roselia | | Azurill | | Shedinja | | Surskit | | Taillow | | Lotad | | Torchic | | Misdreavus | | Murkrow | | Sunkern | | Skiploom | | Hoppip | | Natu | | Togepi | | Igglybuff | | Pichu | | Koffing | | Exeggcute | | Haunter | | Gastly | | Diglett | | Spearow | | Pidgey | | Caterpie | +------------+ 51 rows in set (0.00 sec) mysql> select name, BaseExperience -> from PokeData -> order by BaseExperience DESC -> limit 1 -> ; +--------+----------------+ | name | BaseExperience | +--------+----------------+ | Audino | 390 | +--------+----------------+ 1 row in set (0.00 sec) mysql> select name, BaseExperience from PokeData order by BaseExperience DESC limit 2; +--------+----------------+ | name | BaseExperience | +--------+----------------+ | Audino | 390 | | Zekrom | 306 | +--------+----------------+ 2 rows in set (0.00 sec) mysql> select Name -> from PokeData -> where BaseExperience = 390 -> ; +--------+ | Name | +--------+ | Audino | +--------+ 1 row in set (0.01 sec) mysql> mysql> SELECT MAX(BaseExperience) -> FROm PokeData; +---------------------+ | MAX(BaseExperience) | +---------------------+ | 390 | +---------------------+ 1 row in set (0.01 sec) mysql> select Name -> from PokeData -> where BaseExperience = (SELECT MAX(BaseExperience) -> FROm PokeData ) -> ; +--------+ | Name | +--------+ | Audino | +--------+ 1 row in set (0.00 sec) mysql> select Name -> from PokeData, (SELECT MAX(BaseExperience) as f -> FROm PokeData ) q -> where BaseExperience = q.f -> ; +--------+ | Name | +--------+ | Audino | +--------+ 1 row in set (0.00 sec) mysql> select * from PokeData -> where -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 mysql> create table ttt as (select * from PokeData -> where BaseExperience > 150 and weight > 50 and type = 'water')' '> '> ; '> ' -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ; '' at line 2 mysql> create table ttt as (select * from PokeData where BaseExperience > 150 and weight > 50 and type = 'water'); Query OK, 49 rows affected (0.01 sec) Records: 49 Duplicates: 0 Warnings: 0 mysql> select * from ttt; +------------+-----------+--------+--------+----------------+-------------+-------+------+--------+ | Name | PokedexID | Height | Weight | BaseExperience | Genus | Type | gen | typeId | +------------+-----------+--------+--------+----------------+-------------+-------+------+--------+ | Keldeo | 647 | 14 | 485 | 261 | Colt | water | 4 | 1 | | Alomomola | 594 | 12 | 316 | 165 | Caring | water | 4 | 1 | | Jellicent | 593 | 22 | 1350 | 168 | Floating | water | 4 | 1 | | Swanna | 581 | 13 | 242 | 166 | White Bird | water | 4 | 1 | | Carracosta | 565 | 12 | 810 | 173 | Prototurtle | water | 4 | 1 | | Basculin | 550 | 10 | 180 | 161 | Hostile | water | 4 | 1 | | Seismitoad | 537 | 15 | 620 | 225 | Vibration | water | 4 | 1 | | Simipour | 516 | 10 | 290 | 174 | Geyser | water | 4 | 1 | | Samurott | 503 | 15 | 946 | 238 | Formidable | water | 4 | 1 | | Palkia | 484 | 42 | 3360 | 220 | Spatial | water | 4 | 1 | | Lumineon | 457 | 12 | 240 | 156 | Neon | water | 4 | 1 | | Gastrodon | 423 | 9 | 299 | 176 | Sea Slug | water | 3 | 1 | | Floatzel | 419 | 11 | 335 | 178 | Sea Weasel | water | 3 | 1 | | Empoleon | 395 | 17 | 845 | 210 | Emperor | water | 3 | 1 | | Kyogre | 382 | 45 | 3520 | 218 | Sea Basin | water | 3 | 1 | | Relicanth | 369 | 10 | 234 | 198 | Longevity | water | 3 | 1 | | Gorebyss | 368 | 18 | 226 | 178 | South Sea | water | 3 | 1 | | Huntail | 367 | 17 | 270 | 178 | Deep Sea | water | 3 | 1 | | Milotic | 350 | 62 | 1620 | 213 | Tender | water | 3 | 1 | | Crawdaunt | 342 | 11 | 328 | 161 | Rogue | water | 3 | 1 | | Whiscash | 340 | 9 | 236 | 158 | Whiskers | water | 3 | 1 | | Wailord | 321 | 145 | 3980 | 206 | Float Whale | water | 3 | 1 | | Sharpedo | 319 | 18 | 888 | 175 | Brutal | water | 3 | 1 | | Pelipper | 279 | 12 | 280 | 164 | Water Bird | water | 2 | 1 | | Ludicolo | 272 | 15 | 550 | 181 | Carefree | water | 2 | 1 | | Swampert | 260 | 15 | 819 | 210 | Mud Fish | water | 2 | 1 | | Suicune | 245 | 20 | 1870 | 215 | Aurora | water | 2 | 1 | | Kingdra | 230 | 18 | 1520 | 207 | Dragon | water | 2 | 1 | | Mantine | 226 | 21 | 2200 | 168 | Kite | water | 2 | 1 | | Octillery | 224 | 9 | 285 | 164 | Jet | water | 2 | 1 | | Slowking | 199 | 20 | 795 | 164 | Royal | water | 2 | 1 | | Politoed | 186 | 11 | 339 | 185 | Frog | water | 2 | 1 | | Azumarill | 184 | 8 | 285 | 153 | Aqua Rabbit | water | 2 | 1 | | Lanturn | 171 | 12 | 225 | 156 | Light | water | 2 | 1 | | Feraligatr | 160 | 23 | 888 | 210 | Big Jaw | water | 2 | 1 | | Vaporeon | 134 | 10 | 290 | 196 | Bubble Jet | water | 1 | 1 | | Lapras | 131 | 25 | 2200 | 219 | Transport | water | 1 | 1 | | Gyarados | 130 | 65 | 2350 | 214 | Atrocious | water | 1 | 1 | | Starmie | 121 | 11 | 800 | 207 | Mysterious | water | 1 | 1 | | Seaking | 119 | 13 | 390 | 170 | Goldfish | water | 1 | 1 | | Seadra | 117 | 12 | 250 | 155 | Dragon | water | 1 | 1 | | Kingler | 99 | 13 | 600 | 206 | Pincer | water | 1 | 1 | | Cloyster | 91 | 15 | 1325 | 203 | Bivalve | water | 1 | 1 | | Dewgong | 87 | 17 | 1200 | 176 | Sea Lion | water | 1 | 1 | | Slowbro | 80 | 16 | 785 | 164 | Hermit Crab | water | 1 | 1 | | Tentacruel | 73 | 16 | 550 | 205 | Jellyfish | water | 1 | 1 | | Poliwrath | 62 | 13 | 540 | 185 | Tadpole | water | 1 | 1 | | Golduck | 55 | 17 | 766 | 174 | Duck | water | 1 | 1 | | Blastoise | 9 | 16 | 855 | 210 | Shellfish | water | 1 | 1 | +------------+-----------+--------+--------+----------------+-------------+-------+------+--------+ 49 rows in set (0.00 sec) mysql> create table fff as (select * from PokeData where -> PokeDexId < 200 and height < 30); Query OK, 195 rows affected (0.02 sec) Records: 195 Duplicates: 0 Warnings: 0 mysql> select PokeDexId from fff; +-----------+ | PokeDexId | +-----------+ | 199 | | 198 | | 197 | | 196 | | 195 | | 194 | | 193 | | 192 | | 191 | | 190 | | 189 | | 188 | | 187 | | 186 | | 185 | | 184 | | 183 | | 182 | | 181 | | 180 | | 179 | | 178 | | 177 | | 176 | | 175 | | 174 | | 173 | | 172 | | 171 | | 170 | | 169 | | 168 | | 167 | | 166 | | 165 | | 164 | | 163 | | 162 | | 161 | | 160 | | 159 | | 158 | | 157 | | 156 | | 155 | | 154 | | 153 | | 152 | | 151 | | 150 | | 149 | | 147 | | 146 | | 145 | | 144 | | 143 | | 142 | | 141 | | 140 | | 139 | | 138 | | 137 | | 136 | | 135 | | 134 | | 133 | | 132 | | 131 | | 129 | | 128 | | 127 | | 126 | | 125 | | 124 | | 123 | | 122 | | 121 | | 120 | | 119 | | 118 | | 117 | | 116 | | 115 | | 114 | | 113 | | 112 | | 111 | | 110 | | 109 | | 108 | | 107 | | 106 | | 105 | | 104 | | 103 | | 102 | | 101 | | 100 | | 99 | | 98 | | 97 | | 96 | | 94 | | 93 | | 92 | | 91 | | 90 | | 89 | | 88 | | 87 | | 86 | | 85 | | 84 | | 83 | | 82 | | 81 | | 80 | | 79 | | 78 | | 77 | | 76 | | 75 | | 74 | | 73 | | 72 | | 71 | | 70 | | 69 | | 68 | | 67 | | 66 | | 65 | | 64 | | 63 | | 62 | | 61 | | 60 | | 59 | | 58 | | 57 | | 56 | | 55 | | 54 | | 53 | | 52 | | 51 | | 50 | | 49 | | 48 | | 47 | | 46 | | 45 | | 44 | | 43 | | 42 | | 41 | | 40 | | 39 | | 38 | | 37 | | 36 | | 35 | | 34 | | 33 | | 32 | | 31 | | 30 | | 29 | | 28 | | 27 | | 26 | | 25 | | 23 | | 22 | | 21 | | 20 | | 19 | | 18 | | 17 | | 16 | | 15 | | 14 | | 13 | | 12 | | 11 | | 10 | | 9 | | 8 | | 7 | | 6 | | 5 | | 4 | | 3 | | 2 | | 1 | +-----------+ 195 rows in set (0.01 sec) mysql> SELECT PokeDexId, Name -> FROM ttt -> WHERE ttt.PokeDexId IN (SELECT PokeDexId -> FROM fff -> ) -> ; +-----------+------------+ | PokeDexId | Name | +-----------+------------+ | 199 | Slowking | | 186 | Politoed | | 184 | Azumarill | | 171 | Lanturn | | 160 | Feraligatr | | 134 | Vaporeon | | 131 | Lapras | | 121 | Starmie | | 119 | Seaking | | 117 | Seadra | | 99 | Kingler | | 91 | Cloyster | | 87 | Dewgong | | 80 | Slowbro | | 73 | Tentacruel | | 62 | Poliwrath | | 55 | Golduck | | 9 | Blastoise | +-----------+------------+ 18 rows in set (0.01 sec) mysql> SELECT PokeDexId, Name -> FROM ttt -> WHERE ttt.PokeDexId NOT IN (SELECT PokeDexId -> FROM fff -> ) -> ; +-----------+------------+ | PokeDexId | Name | +-----------+------------+ | 647 | Keldeo | | 594 | Alomomola | | 593 | Jellicent | | 581 | Swanna | | 565 | Carracosta | | 550 | Basculin | | 537 | Seismitoad | | 516 | Simipour | | 503 | Samurott | | 484 | Palkia | | 457 | Lumineon | | 423 | Gastrodon | | 419 | Floatzel | | 395 | Empoleon | | 382 | Kyogre | | 369 | Relicanth | | 368 | Gorebyss | | 367 | Huntail | | 350 | Milotic | | 342 | Crawdaunt | | 340 | Whiscash | | 321 | Wailord | | 319 | Sharpedo | | 279 | Pelipper | | 272 | Ludicolo | | 260 | Swampert | | 245 | Suicune | | 230 | Kingdra | | 226 | Mantine | | 224 | Octillery | | 130 | Gyarados | +-----------+------------+ 31 rows in set (0.02 sec) mysql> select count(*) from ttt; +----------+ | count(*) | +----------+ | 49 | +----------+ 1 row in set (0.00 sec) mysql> select Name from ttt -> where Weight > ALL (select weight from fff); Empty set (0.01 sec) mysql> select Name from ttt where Weight < ALL (select weight from fff); Empty set (0.00 sec) mysql> select Name from fff where Weight > ALL (select weight from ttt); +---------+ | Name | +---------+ | Snorlax | +---------+ 1 row in set (0.01 sec) mysql> select Name from ttt where Weight > ALL (select weight from fff); Empty set (0.01 sec) mysql> select Name from ttt where Weight > ANY (select weight from fff); +------------+ | Name | +------------+ | Keldeo | | Alomomola | | Jellicent | | Swanna | | Carracosta | | Basculin | | Seismitoad | | Simipour | | Samurott | | Palkia | | Lumineon | | Gastrodon | | Floatzel | | Empoleon | | Kyogre | | Relicanth | | Gorebyss | | Huntail | | Milotic | | Crawdaunt | | Whiscash | | Wailord | | Sharpedo | | Pelipper | | Ludicolo | | Swampert | | Suicune | | Kingdra | | Mantine | | Octillery | | Slowking | | Politoed | | Azumarill | | Lanturn | | Feraligatr | | Vaporeon | | Lapras | | Gyarados | | Starmie | | Seaking | | Seadra | | Kingler | | Cloyster | | Dewgong | | Slowbro | | Tentacruel | | Poliwrath | | Golduck | | Blastoise | +------------+ 49 rows in set (0.00 sec) mysql> exit