현재 8개의 리뷰 중 7개의 상태가 'Y', 1개의 상태가 'N'
MOVIE_ID는 모두 동일하게 1427 (== 향수)
조건 순서 1
SELECT COUNT(*)
FROM REVIEW R
LEFT JOIN MEMBER MB USING(USER_NO)
LEFT JOIN MOVIE MV ON(R.MOVIE_ID = MV.MOVIE_ID)
LEFT JOIN TV ON (R.MOVIE_ID = TV.TV_ID)
WHERE REVIEW_STATUS = 'Y'
AND TV.NAME LIKE '%향%' OR MV.TITLE LIKE '%향%';
조건 순서 2
SELECT COUNT(*)
FROM REVIEW R
LEFT JOIN MEMBER MB USING(USER_NO)
LEFT JOIN MOVIE MV ON(R.MOVIE_ID = MV.MOVIE_ID)
LEFT JOIN TV ON (R.MOVIE_ID = TV.TV_ID)
WHERE TV.NAME LIKE '%향%' OR MV.TITLE LIKE '%향%'
AND REVIEW_STATUS = 'Y';