숫자형데이터 실습

mission 1)

SELECT type, AVG(weight)
FROM pokemon.mypokemon
WHERE LENGTH(name)>5
GROUP BY type
HAVING AVG(weight)>=20
ORDER BY 2 DESC ;

 

 

mission 2)

SELECT type, MIN(height), MAX(height)
FROM pokemon.mypokemon
WHERE number<200
GROUP BY type
HAVING MAX(weight)>=10 and MIN(weight)>=2
ORDER BY 2 DESC, 3 DESC;

 

테이블 생성하기

DROP DATABASE IF EXISTS pokemon;
CREATE DATABASE pokemon;
USE pokemon;
CREATE TABLE mypokemon(
number INT,
name VARCHAR(20)
type VARCHAR(10)
height FLOAT
weight FLOAT
);

INSERT INTO mypokemon(number, name, type, height, weight)
VALUES(10,'caterpie', 'bug', 0.3, 2.9)
(25, 'pikachu', electric, 0.4, 6) ;

번개표시 누르기
SELECT * FROM mypokemon;