Back 공블로그

SELECT ANIMAL_ID,NAME FROM ANIMAL_INS WHERE UPPER(NAME) LIKE UPPER('%EL%') AND ANIMAL_TYPE='Dog' ORDER BY NAME ASC;

SELECT ANIMAL_ID,NAME,SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME IN ('Lucy','Ella','Pickle','Rogan','Sabrina','Mitty') ORDER BY ANIMAL_ID ASC;

SELECT * FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE('%네비게이션%') ORDER BY CAR_ID DESC;

SELECT CAR_ID,AVERAGE_DURATION
FROM(
SELECT CAR_ID,ROUND(AVG(END_DATE-START_DATE+1),1) AS AVERAGE_DURATION
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
GROUP BY CAR_ID)
WHERE AVERAGE_DURATION>=7
ORDER BY AVERAGE_DURATION DESC,CAR_ID DESC;

SELECT ORDER_ID,PRODUCT_ID,TO_CHAR(OUT_DATE,'YYYY-MM-DD')AS OUT_DATE,
CASE
    WHEN '2022-05-01'>= TO_CHAR(OUT_DATE,'YYYY-MM-DD') THEN '출고완료'
    WHEN '2022-05-01'< TO_CHAR(OUT_DATE,'YYYY-MM-DD') THEN '출고대기'
    WHEN OUT_DATE IS NULL THEN '출고미정'
    END
AS 출고여부
FROM FOOD_ORDER
ORDER BY ORDER_ID ASC;

SELECT A.APNT_NO, P.PT_NAME, P.PT_NO, D.MCDP_CD, D.DR_NAME,A.APNT_YMD
FROM PATIENT P, DOCTOR D, APPOINTMENT A
WHERE
D.DR_ID=A.MDDR_ID
AND
P.PT_NO=A.PT_NO
AND
A.MCDP_CD='CS' AND A.APNT_CNCL_YN='N' AND TO_CHAR(A.APNT_YMD,'YYYY-MM-DD')='2022-04-13'
ORDER BY APNT_YMD ASC;

SELECT P.PRODUCT_CODE,SUM(P.PRICE*O.SALES_AMOUNT) AS SALES
FROM PRODUCT P JOIN OFFLINE_SALE O
ON P.PRODUCT_ID=O.PRODUCT_ID
GROUP BY P.PRODUCT_CODE
ORDER BY SALES DESC,P.PRODUCT_CODE;

SELECT I.ANIMAL_ID,I.ANIMAL_TYPE,I.NAME
FROM ANIMAL_INS I JOIN ANIMAL_OUTS O
ON I.ANIMAL_ID=O.ANIMAL_ID
WHERE I.SEX_UPON_INTAKE!=O.SEX_UPON_OUTCOME;