PostgreSQL - VIEW

VIEW

-- 원본
SELECT COUNT(*) AS num_shipped, MAX(ship_date), title
    FROM shipments
    JOIN editions USING (isbn)
    NATURAL JOIN books AS b (book_id)
    GROUP BY b.title
    ORDER BY num_shipped DESC;

-- view 만들기
CREATE VIEW recent_shipments
    AS SELECT count(*) AS num_shipped, MAX(ship_date), title
        FROM shipments
            JOIN editions USING (isbn)
            NATURAL JOIN books AS b (book_id)
            GROUP BY b.title
            ORDER BY num_shipped DESC;

-- view 사용
SELECT * FROM recent_shipments;
SELECT * FROM recent_shipments ORDER BY max DESC LIMIT 3;

-- view 삭제
DROP VIEW recent_shipments;