sql basic1 SQL 기본 2 SELECT COUNT(*) FROM users; SELECT COUNT(country) FROM users; SELECT COUNT(DISTINCT country) FROM users; SELECT ROUNT(AVG(pirce),2) AS avgprice FROM products; SELECT MIN(price) FROM products; SELECT SUBSTR(created_at, 1, 10) AS day, SUBSTR(created_at, 1, 7) AS month FROM users; SELECT LENGTH(username), username FROM users; SELECT MIN(LENGTH(username)), username FROM .. 2024. 12. 14. 이전 1 다음
