Advertisement
Guest User

Untitled

a guest
Feb 27th, 2020
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1.  
  2. CREATE TABLE samochód (id INTEGER, nazwa TEXT, model TEXT, moc NUMERIC, prędkość NUMERIC, cena NUMERIC );
  3.  
  4. INSERT INTO samochód VALUES (1, "Opel", "Insignia", "163", "270", "30 000");
  5. INSERT INTO samochód VALUES (2, "Volkswagen", "Golf", "130", "250", "15 000");
  6. INSERT INTO samochód VALUES (3, "Audi", "A4", "105", "250","17 000");
  7. INSERT INTO samochód VALUES (4, "Audi", "TT", "180","260", "10 000");
  8. INSERT INTO samochód VALUES (5, "BMW","5", "180", "250","45 000");
  9. INSERT INTO samochód VALUES (6, "Peugeot", "508", "155","220", "40 000");
  10. INSERT INTO samochód VALUES (7, "Suzuki", "Vitara", "135","200", "50 000");
  11. INSERT INTO samochód VALUES (8, "Mercedes", "AMG GT", "605","310", "700 000");
  12. INSERT INTO samochód VALUES (9, "Mazda", "3", "110","200", "5 000");
  13. INSERT INTO samochód VALUES (10, "Toyota", "Camry", "160","240", "140 000");
  14. SELECT * FROM samochód;
  15. SELECT * FROM samochód order by cena;
  16. SELECT * FROM samochód order by model;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement