칸아카데미>>SQL>>gradebook
CREATE TABLE student_grades ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, number_grade INTEGER, fraction_completed REAL); INSERT INTO student_grades (name, number_grade, fraction_completed) VALUES ("Winston", 90, 0.805);INSERT INTO student_grades (name, number_grade, fraction_completed) VALUES ("Winnefer", 95, 0.901);INSERT INTO student_grades (name, number_grade, fraction_completed) VALUES..
칸아카데미>>SQL>>CASE
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, calories, heart_rate) VALUES ("biking", 10, 30, 105);INSERT INTO exercise_logs(type, minutes, calor..
sql
CREATE TABLE books ( id INTEGER PRIMARY KEY AUTOINCREMENT, author TEXT, title TEXT, words INTEGER); INSERT INTO books (author, title, words) VALUES ("J.K. Rowling", "Harry Potter and the Philosopher's Stone", 79944); INSERT INTO books (author, title, words) VALUES ("J.K. Rowling", "Harry Potter and the Chamber of Secrets", 85141); INSERT INTO books (author, title, words) VALUES ("J.K. Rowling", ..
자바스크립트_객체지향_object
1#var arr = {'name': 'jason', 'age': 20, 'city': 'Seoul' }; Object.keys(arr) ["name", "age", "city"] arr.name "jason" arr.age //20 arr.city //"Seoul" arr.toS //undefined arr.toString toString() { [native code] } 2#var arr = {'name': 'jason', 'age': 20, 'city': 'Seoul' }; arr Object {name: "jason", age: 20, city: "Seoul"} Object.keys(arr) ["name", "age", "city"] 3#var arr = [10,20,30] arr.toStrin..
