Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Basic Statistics

Authors: Charles Henry Brase, Corrinne Pellillo Brase

6th Edition

978-1133525097, 1133525091, 1111827028, 978-1133110316, 1133110312, 978-1111827021

Students also viewed these Databases questions

Question

Solve the focus problem at the beginning of this chapter. Discuss.

Answered: 1 week ago

Question

23. What causes astigmatismpg109

Answered: 1 week ago