There are 19 stations (monitors):

188 => 'AURN Bristol Centre', 203 => 'Brislington Depot', 206 => 'Rupert Street', 209 => 'IKEA M32',

213 => 'Old Market', 215 => 'Parson Street School', 228 => 'Temple Meads Station', 270 => 'Wells Road', 271 => 'Trailer Portway P&R', 375 => 'Newfoundland Road Police Station', 395 => "Shiner's Garage", 452 => 'AURN St Pauls', 447 => 'Bath Road', 459 => 'Cheltenham Road \ Station Road', 463 => 'Fishponds Road', 481 => 'CREATE Centre Roof', 500 => 'Temple Way',

measure

desc

unit

Date Time

Date and time of measurement

datetime

NOx

Concentration of oxides of nitrogen

/m3

NO2

Concentration of nitrogen dioxide

/m3

NO

Concentration of nitric oxide

/m3

SiteID

Site ID for the station

integer

PM10

Concentration of particulate matter <10 micron diameter

/m3

NVPM10

Concentration of non - volatile particulate matter <10 micron diameter

/m3

VPM10

NVPM2.5

Concentration of volatile particulate matter <10 micron diameter

/m3

Concentration of non volatile particulate matter <2.5 micron diameter

/m3

PM2.5

Concentration of particulate matter <2.5 micron diameter

/m3

VPM2.5

Concentration of volatile particulate matter <2.5 micron diameter

/m3

CO

Concentration of carbon monoxide

mg/m3

O3

Concentration of ozone

/m3

SO2

Concentration of sulphur dioxide

/m3

Temperature

Air temperature

C

RH

Relative Humidity

%

Air Pressure

Air Pressure

mbar

Location

Text description of location

text

geo_point_2d

Latitude and longitude

geo point

DateStart

The date monitoring started

datetime

DateEnd

The date monitoring ended

datetime

Current

Is the monitor currently operating

text

Write the SQL query

a. Return the date/time, station name and the highest recorded value of nitrogen oxide (NOx) found in the dataset for the year 2019.

b.Return the mean values of PM2.5 (particulate matter <2.5 micron diameter) & VPM2.5 (volatile particulate matter <2.5 micron diameter) by each station for the year 2019 for readings taken on or near 08:00 hours (peak traffic intensity). c. Extend the previous query to show these values for all stations in the years 2010 to 2019.