Back 공블로그

SELECT NAME,DATETIME
FROM(
SELECT I.NAME,I.DATETIME
FROM ANIMAL_INS I LEFT OUTER JOIN ANIMAL_OUTS O
ON I.ANIMAL_ID=O.ANIMAL_ID
WHERE O.ANIMAL_ID IS NULL
ORDER BY I.DATETIME ASC)
WHERE ROWNUM<=3;

SELECT I.ANIMAL_ID,I.NAME
FROM ANIMAL_INS I JOIN ANIMAL_OUTS O ON I.ANIMAL_ID=O.ANIMAL_ID
WHERE I.DATETIME-O.DATETIME>0
ORDER BY I.DATETIME ASC;

SELECT ANIMAL_ID,NAME FROM ANIMAL_OUTS
MINUS
SELECT O.ANIMAL_ID,O.NAME
FROM ANIMAL_INS I JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
ORDER BY ANIMAL_ID ASC;

SELECT FLAVOR FROM(
SELECT F.FLAVOR,SUM(F.TOTAL_ORDER+J.TOTAL_ORDER) AS AMOUNT
FROM FIRST_HALF F,JULY J
WHERE F.FLAVOR=J.FLAVOR
GROUP BY F.FLAVOR
ORDER BY AMOUNT DESC
)
WHERE ROWNUM<=3;

WITH TEST AS
(
SELECT M.MEMBER_NAME,R.MEMBER_ID,COUNT(R.MEMBER_ID) AS COUNTING
FROM MEMBER_PROFILE M JOIN REST_REVIEW R
ON M.MEMBER_ID=R.MEMBER_ID
GROUP BY R.MEMBER_ID,M.MEMBER_NAME
)
SELECT T.MEMBER_NAME,R.REVIEW_TEXT,TO_CHAR(R.REVIEW_DATE,'YYYY-MM-DD') AS REVIEW_DATE
FROM TEST T JOIN REST_REVIEW R
ON T.MEMBER_ID=R.MEMBER_ID
WHERE 
T.COUNTING IN (SELECT MAX(T.COUNTING) FROM TEST T)
ORDER BY R.REVIEW_DATE ASC,R.REVIEW_TEXT ASC;

SELECT BOOK_ID,AUTHOR_NAME,TO_CHAR(PUBLISHED_DATE,'YYYY-MM-DD') PUBLISHED_DATE
FROM BOOK B JOIN AUTHOR A ON B.AUTHOR_ID=A.AUTHOR_ID
WHERE CATEGORY = '경제' 
ORDER BY PUBLISHED_DATE ASC;