Database Reference
In-Depth Information
(i) For cities operated by more than one airport, give the total number
of arriving and departing passengers at the airport closest to the
city center and the ratio between this value and the city total.
(j) Display the spatial union of all airports located at more than
1,000m above sea level.
(k) Compare the number of departed and scheduled flights for airports
located above and below 1,000m above sea level in 2012.
11.6
Write in SQL the queries of Ex.
11.5
over the logical schema obtained
in Ex.
11.3
.
Search WWH ::
Custom Search