기타
2. SQL 궁금증 고민 1 : HAVING AS 오류
코드잇 SQL 강의 Topic 1-6. 09 FROM 절에 있는 서브쿼리 中 # 1 SELECT SUBSTRING(address, 1, 2) FROM review AS r LEFT OUTER JOIN `member` AS m ON r.mem_id = m.id GROUP BY SUBSTRING(address, 1, 2) HAVING SUBSTRING(address, 1, 2) IS NOT NULL AND SUBSTRING(address, 1, 2) != '안드'; # 2 SELECT SUBSTRING(address, 1, 2) AS region FROM review AS r LEFT OUTER JOIN `member` AS m ON r.mem_id = m.id GROUP BY SUBSTRING(addres..
