본문 바로가기
반응형

SQL39

[프로그래머스 - ORACLE] 5월 식품들의 총매출 조회하기 CREATE 문 CREATE TABLE FOOD_PRODUCT ( PRODUCT_IDVARCHAR(10)NOT NULL, PRODUCT_NAMEVARCHAR(50)NOT NULL, PRODUCT_CDVARCHAR(10)NULL, CATEGORYVARCHAR(10)NULL, PRICENUMBERNULL ) CREATE TABLE FOOD_ORDER ( ORDER_IDVARCHAR(10)NOT NULL, PRODUCT_IDVARCHAR(5)NOT NULL, AMOUNTNUMBERNOT NULL, PRODUCE_DATEDATENULL, IN_DATEDATENULL, OUT_DATEDATENULL, FACTORY_IDVARCHAR(10)NOT NULL, WAREHOUSE_IDVARCHAR(10)NOT NULL .. 2023. 3. 23.
[프로그래머스 - ORACLE] 식품분류별 가장 비싼 식품의 정보 조회하기 CREATE 문 CREATE TABLE FOOD_PRODUCT ( PRODUCT_IDVARCHAR(10)NOT NULL, PRODUCT_NAMEVARCHAR(50)NOT NULL, PRODUCT_CDVARCHAR(10)NULL, CATEGORYVARCHAR(10)NULL, PRICENUMBERNULL ) 내 풀이 SELECT CATEGORY, PRICE AS MAX_PRICE, PRODUCT_NAME FROM FOOD_PRODUCT WHERE (CATEGORY, PRICE) IN (SELECT CATEGORY, MAX(PRICE) AS MAX_PRICE FROM FOOD_PRODUCT WHERE CATEGORY IN ('과자' , '국' , '식용유' ,'김치') GROUP BY CATEGORY ) OR.. 2023. 3. 23.
[프로그래머스 - ORACLE] 우유와 요거트가 담긴 장바구니 CREATE 문 CREATE TABLE CART_PRODUCTS ( IDNUMBER, CART_IDNUMBER, NAMEVARCHAR(30) PRICENUMBER ) 내 풀이 SELECT A.CART_ID FROM CART_PRODUCTS A INNER JOIN CART_PRODUCTS B ON A.CART_ID = B.CART_ID AND A.NAME = 'Milk' AND B.NAME = 'Yogurt' ORDER BY CART_ID ASC 2023. 3. 23.
[프로그래머스 - ORACLE] 입양 시각 구하기(2) CREATE 문 CREATE TABLE ANIMAL_OUTS ( ANIMAL_IDVARCHAR(50)NOT NULL, ANIMAL_TYPEVARCHAR(50)NOT NULL, DATETIMETIMESTAMPNOT NULL, NAMEVARCHAR(50)NULL, SEX_UPON_OUTCOMEVARCHAR(50)NOT NULL ); 내 풀이 SELECT A.HOUR, COUNT(B.HOUR) AS COUNT FROM (SELECT LEVEL - 1 AS HOUR FROM DUAL CONNECT BY LEVEL 2023. 3. 23.
[프로그래머스 - ORACLE] 보호소에서 중성화한 동물 CREATE 문 CREATE TABLE ANIMAL_INS ( ANIMAL_IDVARCHAR(50)NOT NULL PRIMARY KEY, ANIMAL_TYPEVARCHAR(50)NOT NULL, DATETIMETIMESTAMPNOT NULL, INTAKE_CONDITIONVARCHAR(50)NOT NULL, NAMEVARCHAR(50)NULL, SEX_UPON_INTAKEVARCHAR(50)NOT NULL ); CREATE TABLE ANIMAL_OUTS ( ANIMAL_IDVARCHAR(50)NOT NULL, ANIMAL_TYPEVARCHAR(50)NOT NULL, DATETIMETIMESTAMPNOT NULL, NAMEVARCHAR(50)NULL, SEX_UPON_OUTCOMEVARCHAR(50)NO.. 2023. 3. 23.
[프로그래머스 - ORACLE] 특정 기간동안 대여 가능한 자동차들의 대여비용 구하기 CREATE 문 CREATE TABLE CAR_RENTAL_COMPANY_CAR ( CAR_IDNUMBER NOT NULL, CAR_TYPEVARCHAR(255)NOT NULL, DAILY_FEENUMBER NOT NULL, OPTIONSVARCHAR(255)NOT NULL ); CREATE TABLE CAR_RENTAL_COMPANY_RENTAL_HISTORY ( HISTORY_IDNUMBERNOT NULL, CAR_IDNUMBERNOT NULL, START_DATEDATENOT NULL, END_DATEDATENOT NULL ); CREATE TABLE CAR_RENTAL_COMPANY_DISCOUNT_PLAN ( PLAN_IDNUMBER NOT NULL, CAR_TYPEVARCHAR(255)NOT .. 2023. 3. 22.
반응형

티스토리툴바