비교연산자, LIKE, BETWEEN, IN 예제

 

mission 1)
USE pokemon;
SELECT type
FROM mypokemon
WHERE name='eevee';

mission 2)
SELECT attack, defense
FROM mypokemon
WHERE name ='catepie';

mission 3)
SELECT *
FROM mypokemon
WHERE weight >6 ;

mission 4)
SELECT name
FROM mypokemon
WHERE height>0.5 AND weight>=6;

mission 5)
SELECT name AS weak_pokemon
FROM mypokemon
WHERE attack<50 OR defense<50 ;

mission 6)
SELECT *
FROM mypokemon
WHERE type!='normal';

mission 7)
SELECT name, type
FROM mypokemon
WHERE type IN ('normal', 'fire', 'water', 'grass');

mission 8)
SELECT name, attack
FROM mypokemon
WHERE attack BETWEEN 40 AND 60;

mission 9)
SELECT name
FROM mypokemon
WHERE name LIKE '%e%';

mission 10)
SELECT *
FROM mypokemon
WHERE name LIKE '%i%' AND speed <=50;

mission 11)
SELECT name, height, weight
FROM mypokemon
WHERE name LIKE '%chu';

mission 12)
SELECT name, defense
FROM mypokemon
WHERE name LIKE '%e' and defense <50;

mission 13)
SELECT name, attack, defense
FROM mypokemon
WHERE (attack-defense) >=10 OR (defense-attack) >=10 ;

mission 14)
SELECT name, attack+defense+speed AS total
FROM mypokemon
WHERE attack+defense+speed >=150;

 

테이블 생성하기~

DROP DATABASE IF EXISTS pokemon;
CREATE DATABASE pokemon;
USE pokemon;

CREATE TABLE mypokemon(
number INT,
name VARCHAR(20),
type VARCHAR(20),
height FLOAT,
weight FLOAT,
attack FLOAT,
defense FLOAT,
speed FLOAT
);

INSERT INTO mypokemon(number, name, type, height, weight, attack, defense, speed)
VALUES (10, 'caterpie', 'bug', 0.3, 2.9, 30, 35, 45),