SELECT (data from multiple tables)

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

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

4) In order to interrogate your DATASET, your need to write queries....

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

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

--Some sample SELECT queries...which will only show you what you want to see from the table, but a SELECT statement will not change the tables in any way.

select * from car_sales

select * from car_dealership

--This SELECT will give you ALL RECORDS and ALL FIELDS, across both tables.

select car_sales.*, car_dealership.*

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

select car_sales.*, car_dealership.*

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

order by car_sales.make asc

--This SELECT will give you ALL RECORDS and CERTAIN FIELDS, across both tables.

select car_sales.registration, car_sales.make, car_sales.model, car_dealership.dealership_city, car_dealership.dealership_postcode

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

--This SELECT will give you CERTAIN RECORDS and CERTAIN FIELDS, across both tables.

select car_sales.registration, car_sales.make, car_sales.model, car_dealership.dealership_city, car_dealership.dealership_postcode

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

 and car_dealership.dealership_postcode = 'L4 0TH'

select car_sales.registration, car_sales.make, car_sales.model, car_dealership.dealership_city, car_dealership.dealership_postcode

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

 and car_dealership.dealership_postcode = 'EC2A 6YT'

select car_sales.registration, car_sales.make, car_sales.model, car_dealership.dealership_city, car_dealership.dealership_postcode

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

 and car_dealership.dealership_postcode = 'M16 0RA'

select car_sales.registration, car_sales.make, car_sales.model, car_dealership.dealership_city, car_dealership.dealership_postcode

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

 and car_sales.make = 'bmw'

select sum(car_sales.sold_price)

from car_sales, car_dealership 

where car_sales.dealership_postcode = car_dealership.dealership_postcode

 and car_dealership.dealership_city = 'Liverpool'