몬그로이

인기있는 아이스크림https://school.programmers.co.kr/learn/courses/30/lessons/133024SELECT FLAVORFROM FIRST_HALFORDER BY TOTAL_ORDER DESC, SHIPMENT_ID 12세 이하인 여자 환자 목록 출력하https://school.programmers.co.kr/learn/courses/30/lessons/132201SELECT PT_NAME, PT_NO, GEND_CD, AGE, IFNULL(TLNO, 'NONE') AS TLNOFROM PATIENTWHERE GEND_CD = 'W' AND AGE 12ORDER BY AGE DESC, PT_NAME java ) 두 정수 사이의 합https://school.program..

강원도에 위치한 생산공장 목록 출력하기https://school.programmers.co.kr/learn/courses/30/lessons/131112SELECT FACTORY_ID, FACTORY_NAME, ADDRESSFROM FOOD_FACTORYWHERE ADDRESS LIKE '%강원도%'ORDER BY FACTORY_ID ASC 이름이 없는 동물의 아이디https://school.programmers.co.kr/learn/courses/30/lessons/59039SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NULLORDER BY ANIMAL_ID ASC 조건에 맞는 회원수 구하기https://school.programmers.co.kr/learn/cour..

나이 정보가 없는 회원 수 구하기\https://school.programmers.co.kr/learn/courses/30/lessons/131528SELECT COUNT(USER_ID) USERSFROM USER_INFOWHERE AGE IS NULL 가장 비싼 상품 구하기https://school.programmers.co.kr/learn/courses/30/lessons/131697SELECT MAX(PRICE) MAX_PRICEFROM PRODUCTORDER BY PRICE DESC 흉부외과 또는 일반외과 의사 목록 출력하기https://school.programmers.co.kr/learn/courses/30/lessons/132203SELECT DR_NAME, DR_ID, MCDP_CD, DA..

상위 n개 레코드https://school.programmers.co.kr/learn/courses/30/lessons/59405  SELECT NAME FROM  ANIMAL_INS ORDER BY DATETIMELIMIT1 이름이 있는 동물의 아이디https://school.programmers.co.kr/learn/courses/30/lessons/59407SELECT ANIMAL_ID FROM  ANIMAL_INS WHERE  name IS NOT NULL ORDER  BY  ANIMAL_ID 경기도에 위치한 식품창고 목록 출력하기https://school.programmers.co.kr/learn/courses/30/lessons/131114SELECT WAREHOUSE_ID, WAREHOUSE..

역순 정렬하기https://school.programmers.co.kr/learn/courses/30/lessons/59035SELECT name, DATETIMEfrom animal_insorder by ANIMAL_ID desc 동물의 아이디와 이름https://school.programmers.co.kr/learn/courses/30/lessons/59403SELECT ANIMAL_ID, NAMEfrom ANIMAL_INSorder by ANIMAL_Id 여러 기준으로 정렬하기https://school.programmers.co.kr/learn/courses/30/lessons/59404select ANIMAL_ID, NAME, DATETIMEfrom ANIMAL_INSorder by NAME, D..