Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE samochody (id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER, Model INTEGER);
- INSERT INTO samochody VALUES (1, "Bananas", 56, 7);
- INSERT INTO samochody VALUES(2, "Peanut Butter", 1, 2);
- INSERT INTO samochody VALUES(3, "Dark Chocolate Bars", 2, 2);
- INSERT INTO samochody VALUES(4, "Ice cream", 1, 12);
- INSERT INTO samochody VALUES(5, "Cherries", 6, 2);
- INSERT INTO samochody VALUES(6, "Chocolate syrup", 1, 4);
- SELECT Model, SUM(quantity) FROM groceries GROUP BY aisle;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement