FULL SCRIPT to create two popoulated tables

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

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

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

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

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

--drop table car_sales

create table car_sales

(

registration varchar(10) ,

make varchar(20) ,

model varchar(20) ,

purchase_price int ,

purchase_date date ,

sold_price int ,

sold_date date ,

dealership_postcode varchar(10)

)

select * from car_sales

--drop table car_dealership

create table car_dealership

(

dealership_name varchar(20) ,

dealership_road varchar(30) ,

dealership_city varchar(30) ,

dealership_postcode varchar(10) 

)

select * from car_dealership

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

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

2) now populate your tables, here....

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

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

--populate car_sales table

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

values('PO91CHE','porsche','911',100678,'20190419',110321,'20200117','L4 0TH')

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

values('BM33TOU','bmw','m3 touring',80123,'20200401',90432,'20200605','L4 0TH')

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

values('BM34QWE','bmw','m3 touring',81444,'20200401',93500,'20200605','L4 0TH')

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

values('SE12ALH','seat','alhambra',19000,'20200701',25000,'20200714','L4 0TH')

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

values('LA12HOU','lamborghini','hourican',251000,'20210218',285000,'20210220','L4 0TH')

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

values('RS66AUD','audi','RS6',65765,'20210301',85999,'20210410','EC2A 6YT')

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

values('VW12TOU','vw','touran',18000,'20190221',22950,'20210411','EC2A 6YT')

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

values('FE90ROR','ferrari','sf90',235000,'20210815',290999,'20210816','EC2A 6YT')

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

values('ME78CED','mercedes','eq90',100000,'20210501',105000,'20210513','M16 0RA')

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

values('BM33IRS','bmw','330i',45000,'20210501',55000,'20210513','M16 0RA')

--populate car_dealership table

insert into car_dealership (dealership_name,dealership_road,dealership_city,dealership_postcode)

values ('north','1 Anfield way','Liverpool','L4 0TH')

insert into car_dealership (dealership_name,dealership_road,dealership_city,dealership_postcode)

values ('south','10 Park Lane','London','EC2A 6YT')

insert into car_dealership (dealership_name,dealership_road,dealership_city,dealership_postcode)

values ('north','1 Old Trafford Way','Manchester','M16 0RA')

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

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

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

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

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

select * from car_sales

select * from car_dealership