-- create a table
CREATE TABLE car_database(
  car_make TEXT,
  car_model TEXT,
  car_year TEXT,
  price INTEGER
);

-- insert some values
INSERT INTO car_database VALUES ('dodge', 'NULL', '2018', 18000);
INSERT INTO car_database VALUES ('ford', 'focus', '2018', 18000);
INSERT INTO car_database VALUES ('ford', 'explorer', '2019', 21000);
INSERT INTO car_database VALUES (NULL, 'ram', '2019', 32000);
INSERT INTO car_database VALUES ('dodge', 'durango', '2020', 16000);
INSERT INTO car_database VALUES ('ford', 'focus', '2020', 17000);
INSERT INTO car_database VALUES ('ford', 'explorer', '2017', 17000);
INSERT INTO car_database VALUES ('dodge', 'ram', '2017', 12000);
INSERT INTO car_database VALUES (NULL, 'outlander', '2016', 13000);
INSERT INTO car_database VALUES (NULL, 'outlander', NULL, 18000);
INSERT INTO car_database VALUES ('GMC', 'Terrain', NULL, 18000);
INSERT INTO car_database VALUES ('GMC', 'Sierra', '2018', 21000);
INSERT INTO car_database VALUES ('ford', 'explorer', '2019', 32000);
INSERT INTO car_database VALUES ('dodge', NULL, '2019', 16000);
INSERT INTO car_database VALUES ('mitsubishi', NULL, '2020', 17000);
INSERT INTO car_database VALUES ('mitsubishi', 'outlander', '2020', NULL);
INSERT INTO car_database VALUES ('GMC', 'Terrain', '2017', NULL);
INSERT INTO car_database VALUES ('GMC', 'Sierra', '2017', 13000);