FULL SCRIPT to create a popoulated table

/*******************************

*******************************

1) create the table first, here....

*******************************

*********************************/

create table car_sales

(

make varchar(20) ,

model varchar(20) ,

purchase_price int ,

purchase_date date ,

sold_price int ,

sold_date date ,

carname varchar(40) ,

EmptyField varchar(20)

)

/*******************************

*******************************

2) now populate the table, here....

*******************************

*********************************/

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('porscheeeee','911',100678,'20190419',110321,'20200117','porsche 911')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('bmw','m3 touring',80123,'20200401',904320,'20200605','bmw m3 touring')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('seat','alhambra',19000,'20200701',25000,'20200714','seat alhambra')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('lambourgini','hourican',250000,'20210218',2850000,'20210220','lambourgini hourican')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('testmake','testcar',0,'19000101',0,'19000101','testdata')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('auuuudi','RS6',65765,'20210301',85999,'20210410','audi RS6')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('vvw','touran',18000,'20190221',22950,'20210411','vw touran')

insert into car_sales(make,model,purchase_price,purchase_date,sold_price,sold_date,carname)

values('ferrari','sf90',235000,'20210815',290999,'20210816','ferrari sf90')

/*******************************

*******************************

3) have a look at your populated table here....

*******************************

*********************************/

select * from car_sales