Question
There are 19 stations (monitors): 188 => 'AURN Bristol Centre', 203 => 'Brislington Depot', 206 => 'Rupert Street', 209 => 'IKEA M32', 213 => 'Old
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started