SQL 4.grade

Create a table in SQL with the name 'cars' with columns id, name, type, age, price.

(a)  

What is missing in the code if you want to filter all cars older than 2015 year?

• WHERE

• OR

• AND

• ORDER

What is missing in the code below to show all cars cheaper than 15000KM and younger than 2010 year?

• WHERE, AND, WHERE

• WHERE, OR, WHERE

• WHERE, OR, ORDER

• WHERE, AND, ORDER

Write a command that will order all cars by price (from the cheapest to the most expensive).

(a)  

Write a command that will order all cars by age (from the oldest to the youngest).

(a)  

Write a command that will show the most expensive car.

(a)  

Write a command that will show the oldest car.

(a)  

If you want to show only 2 columns from table what would you choose it?

• SELECT type1, price FROM cars;

• SELECT type1, price, age FROM cars;

• SELECT type, price FROM cars;

• SELECT type1, price FROM groceries;

Write line of code which will insert new car in table with only next datas (name:"Golf8", age: 2023).

(a)  

CREATE TABLE cars (id INTEGER PRIMARY KEY, name TEXT, type1 TEXT, age INTEGER,

price INTEGER);

INSERT INTO cars VALUES (1, 'Toyota Corolla', 'Sedan', 2018, 15000);

INSERT INTO cars VALUES (2, 'Ford Mustang', 'Sports', 2001, 3000);

INSERT INTO cars VALUES (3, 'Honda Civic', 'Sedan', 2016, 12000);

INSERT INTO cars VALUES (4, 'Chevrolet Camaro', 'Sports', 2022, 32000);

INSERT INTO cars VALUES (5, 'Ford F-150', 'Truck', 2007, 28000);

INSERT INTO cars VALUES (6, 'Tesla Model 3', 'Electric', 2023, 35000);

INSERT INTO cars VALUES (7, 'Toyota Prius', 'Hybrid', 2019, 18000);

INSERT INTO cars VALUES (8, 'BMW X5', 'SUV', 2003, 5000);

INSERT INTO cars VALUES (9, 'Audi A4', 'Sedan', 2019, 25000);

INSERT INTO cars VALUES (10, 'Jeep Wrangler', 'SUV', 2021, 32000);

INSERT INTO cars VALUES (11, 'Hyundai Sonata', 'Sedan', 2017, 14000);

INSERT INTO cars VALUES (12, 'Kia Sorento', 'SUV', 2018, 22000);

INSERT INTO cars VALUES (13, 'Nissan Leaf', 'Electric', 2010, 17000);

INSERT INTO cars VALUES (14, 'Mercedes-Benz C-Class', 'Sedan', 2019, 33000);

INSERT INTO cars VALUES (15, 'Chevrolet Silverado', 'Truck', 2006, 7000);

SELECT * FROM cars WHERE price > 22000 OR WHERE age = 2020 ORDER BY price;

• show all cars cheaper than 22000 and older than 2020

• show all cars more expensive than 21000 and older than 2020

• show all cars more expensive than 22000 and produces in 2020

• show all cars more expensive than 22000 and younger than 2020