Thread:Light.Runner.Explorer/@comment-25812815-20141204184423/@comment-25768713-20141205050130

CREATE TABLE todo_list (id INTEGER PRIMARY KEY, item TEXT, minutes INTEGER);INSERT INTO todo_list VALUES (1, "Wash the dishes", 15);INSERT INTO todo_list VALUES (2, "vacuuming", 20);INSERT INTO todo_list VALUES (3, "Learn some stuff on KA", 30);INSERT INTO todo_list VALUES (4, "Earning EP", 100);SELECT minutes, SUM(minutes) FROM todo_list;