-- create a table
CREATE TABLE CARS (
  id INTEGER,
  marca TEXT NOT NULL,
  submarca TEXT NOT NULL,
  modelo integer,
  precio int,
  concesionario varchar
);
-- insert some values
INSERT INTO CARS VALUES (1, 'Porsche', 'Macan',2022,3000000,'L.A');
INSERT INTO CARS VALUES (2, 'Cupra', 'Formentor',2022,800000,'L.A');
INSERT INTO CARS VALUES (3, 'Audi', 'A1',2022,600000,'L.A');
INSERT INTO CARS VALUES (4, 'BMW', 'Series 1',2022,1000000,'L.A');
-- fetch some values
SELECT *FROM CARS;