SHARE
TWEET

qwerty

a guest Feb 26th, 2020 91 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE samochody (id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER, Model INTEGER);
  2. INSERT INTO samochody VALUES (1, "Bananas", 56, 7);
  3. INSERT INTO samochody VALUES(2, "Peanut Butter", 1, 2);
  4. INSERT INTO samochody VALUES(3, "Dark Chocolate Bars", 2, 2);
  5. INSERT INTO samochody VALUES(4, "Ice cream", 1, 12);
  6. INSERT INTO samochody VALUES(5, "Cherries", 6, 2);
  7. INSERT INTO samochody VALUES(6, "Chocolate syrup", 1, 4);
  8.  
  9. SELECT Model, SUM(quantity) FROM groceries GROUP BY aisle;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top