[SQL] 고급 기능인 CASE,WHEN,THEN,ELSE,END
https://ko.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/calculating-results-with-case 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, 100, 110); INSERT INTO exercise_logs(type, minutes, calorie..
프로그래밍 공부/데이터베이스 & SQL
2024. 2. 21. 21:23