[SQL] CREATE, INSERT INTO VALUES, SELECT FROM

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),
(25, 'pikachu', 'electric', 0.4, 6, 55, 40, 90),
(26, 'raichu', 'electric', 0.8, 30, 90, 55, 110),
(133, 'eevee', 'normal', 0.3, 6.5, 55, 50, 55),
(152, 'chikoirita', 'grass', 0.9, 6.4, 49, 65, 45);

select '피카츄' as '포켓몬';
SELECT * 
FROM mypokemon;
SELECT name 
FROM mypokemon;
SELECT name,height,weight 
FROM mypokemon;
SELECT DISTINCT height 
FROM mypokemon;
SELECT name, attack*2 AS attack2 
FROM mypokemon;
SELECT name AS 이름 
FROM mypokemon;
SELECT attack AS 공격력, defense AS 방어력 
FROM mypokemon;
SELECT height*100 AS "height(cm)" 
FROM mypokemon;
SELECT * 
FROM mypokemon 
LIMIT 1;
SELECT name AS 영문명, height AS "키(m)", weight AS "몸무게(kg)" 
FROM mypokemon LIMIT 2;
SELECT name, attack+defense+speed AS total 
FROM mypokemon;
SELECT name, weight/(height)^2 AS BMI 
FROM mypokemon;