GROUP BY, Having 실습

ㄹㅇ

mission 1)
SELECT type, AVG(height)
FROM mypokemon
GROUP BY type;

mission 2)
SELECT type, AVG(weight)
FROM mypokemon
GROUP BY type;

mission 3)
SELECT type, AVG(height), AVG(weight)
FROM mypokemon
GROUP BY type;

mission 4)
SELECT type
FROM mypokemon
GROUP BY type
HAVING AVG(height)>=0.5;

mission 5)
SELECT type
FROM mypokemon
GROUP BY type
HAVING AVG(weight)>=20;

mission 6)
SELECT type, SUM(number)
FROM mypokemon
GROUP BY type;

mission 7)
SELECT type, COUNT(1), COUNT(*)
FROM mypokemon
WHERE height>=0.5
GROUP BY type;

mission 8)
SELECT type, MIN(height)
FROM mypokemon
GROUP BY type;

mission 9)
SELECT type, MAX(weight)
FROM mypokemon
GROUP BY type;

mission 10)
SELECT type
FROM mypokemon
GROUP BY type
HAVING MIN(height)>0.5 AND MAX(weight)<30;