SQL문 연습

SELECT     *
FROM         dbo.F_CODE

SELECT     SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG
FROM         dbo.F_FESTIVAL
WHERE     (FESTIVAL LIKE '고궁축제')

SELECT     SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG
FROM         dbo.F_FESTIVAL
WHERE     (OPEN_MM LIKE '3') AND (SUNJUNG LIKE '1')

SELECT     SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG
FROM         dbo.F_FESTIVAL
WHERE     (OPEN_MM LIKE '3') OR
                      (OPEN_MM LIKE '4') AND (SUNJUNG LIKE '1')
ORDER BY OPEN_MM