SQL124 [프로그래머스 / SQL] 성분으로 구분한 아이스크림 총 주문량 -CodeSELECT INGREDIENT_TYPE, SUM(TOTAL_ORDER) AS TOTAL_ORDERFROM FIRST_HALF AS FH JOIN ICECREAM_INFO AS II ON FH.FLAVOR = II.FLAVORGROUP BY II.INGREDIENT_TYPE; 2025. 7. 14. [프로그래머스 / SQL] 고양이와 개는 몇 마리 있을까 -CodeSELECT ANIMAL_TYPE, COUNT(*) AS COUNTFROM ANIMAL_INSWHERE ANIMAL_TYPE = 'Cat' OR ANIMAL_TYPE = 'Dog'GROUP BY ANIMAL_TYPEORDER BY ANIMAL_TYPE; 2025. 7. 14. [프로그래머스 / SQL] 진료과별 총 예약 횟수 출력하기 -CodeSELECT MCDP_CD AS '진료과코드', COUNT(*) AS '5월예약건수'FROM APPOINTMENTWHERE YEAR(APNT_YMD) = 2022 AND MONTH(APNT_YMD) = 5GROUP BY MCDP_CDORDER BY COUNT(*), MCDP_CD; 2025. 7. 14. [프로그래머스 / SQL] 중성화 여부 파악하기 -CodeSELECT ANIMAL_ID, NAME, ( CASE WHEN ( SEX_UPON_INTAKE LIKE '%NEUTERED%' OR SEX_UPON_INTAKE LIKE '%SPAYED%' ) THEN 'O' ELSE 'X' END ) AS '중성화'FROM ANIMAL_INS ORDER BY ANIMAL_ID; 2025. 7. 14. [프로그래머스 / SQL] 카테고리 별 상품 개수 구하기 -CodeSELECT LEFT(PRODUCT_CODE, 2) AS CATEGORY, COUNT(PRODUCT_CODE)FROM PRODUCT GROUP BY CATEGORYHAVING COUNT(LEFT(PRODUCT_CODE, 2)) > 0ORDER BY CATEGORY ASC; 2025. 7. 13. [프로그래머스 / SQL] 상품 별 오프라인 매출 구하기 -CodeSELECT P.PRODUCT_CODE, SUM(OS.SALES_AMOUNT) * P.PRICE AS SALESFROM PRODUCT AS P JOIN OFFLINE_SALE AS OS ON P.PRODUCT_ID = OS.PRODUCT_IDGROUP BY P.PRODUCT_CODEORDER BY SALES DESC, P.PRODUCT_CODE; 2025. 7. 12. 이전 1 ··· 9 10 11 12 13 14 15 ··· 21 다음
