dimanche 3 mai 2020

i want to make the minutes add up but it seems to not work

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