Post

Day1

https://school.programmers.co.kr/learn/courses/30/lessons/59407

SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL;

https://school.programmers.co.kr/learn/courses/30/lessons/59035

SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID DESC;

https://school.programmers.co.kr/learn/courses/30/lessons/59408

SELECT SUM(CNT) AS CNT FROM ( SELECT COUNT(DISTINCT(NAME)) AS CNT FROM ANIMAL_INS WHERE NAME IS NOT NULL ) A;

SELECT SUM(NAME) COUNT FROM ( SELECT COUNT(DISTINCT(NAME)) AS NAME FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME ) A GROUP BY NAME;

This post is licensed under CC BY 4.0 by the author.