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