sql 쿼리문 연습1 [Database/MySQL] 기초 쿼리문 연습 1.SELECT titleFROM BOOK WHERE title LIKE "%데이터%"; 2. SELECT COUNT(title) # SELECT COUNT(*)FROM BOOK WHERE title LIKE "%데이터%"; 3. SELECT AVG(price) FROM BOOK WHERE title LIKE "%데이터%"; 4. SELECT *FROM CUSTOMERWHERE address = "Seoul"; 5. SELECT COUNT(cust_no) # SELECT COUNT(*)FROM CUSTOMERWHERE address = "Seoul"; 6.SELECT COUNT(*) FROM ORDER_TABLEWHERE book_no = 3; 7.SELECT AVG(IF.. 2024. 10. 22. 이전 1 다음 728x90
