춘식이2
업글이✧
춘식이2
전체 방문자
오늘
어제
  • 분류 전체보기
    • Data Analysis
    • Python
    • SQL
    • Statistics

블로그 메뉴

  • 홈
  • 태그
  • 방명록

공지사항

인기 글

태그

  • NVL
  • Jupyter
  • sql튜닝
  • 장바구니분석
  • SQL
  • rank함수
  • Apriori
  • 데이터분석
  • python3
  • window함수
  • pv
  • uv
  • coalesce
  • Python
  • NULL
  • ifnull
  • Codility
  • excel
  • 데이터디스커버리
  • hackerrank

최근 댓글

최근 글

티스토리

hELLO · Designed By 정상우.
춘식이2

업글이✧

SQL

GROUP BY, Having 실습

2022. 6. 27. 13:27

ㄹㅇ

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;

'SQL' 카테고리의 다른 글

UDF(User Define Function), Delimiter  (0) 2022.06.27
IF, SUM IF, IFNULL, CASE WHEN  (0) 2022.06.27
숫자형데이터 실습  (0) 2022.06.27
쿼리실행순서  (0) 2022.06.27
문자형 데이터 실습  (0) 2022.06.27
    'SQL' 카테고리의 다른 글
    • UDF(User Define Function), Delimiter
    • IF, SUM IF, IFNULL, CASE WHEN
    • 숫자형데이터 실습
    • 쿼리실행순서
    춘식이2
    춘식이2

    티스토리툴바