I have no clue why its not working I have tried group by and order by but it doesn't seem to accept it can you double check and tell me what I need to do Thanks
code
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, "netflix", 12);
SELECT item, SUM(minutes) FROM todo_list GROUP BY item;
I been using a example from khan academy and an error shows up Error: Hm, are you sure you're selecting the total sum of the minutes across all of the items?
Can you tell me what I can do to fix it . thanks
Aucun commentaire:
Enregistrer un commentaire