[SQL] HAVING, AS(이름 재설정), COUNT
https://ko.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/restricting-grouped-results-with-having CREATE TABLE exercise_logs (id INTEGER PRIMARY KEY AUTOINCREMENT, type TEXT, minutes INTEGER, calories INTEGER, heart_rate INTEGER); INSERT INTO exercise_logs(type, minutes, calories, heart_rate) VALUES ("biking", 30, 115, 110); INSERT INTO exercise_logs(type, minute..
프로그래밍 공부/데이터베이스 & SQL
2024. 2. 21. 20:57