Guidelines > University of Iowa - 06K 230hw3-solution.sql: hw3-queries.sql -- homework 3 sample solution (queries and indexes)


Qa. For each origin city, find the destination city (or cities) thatis farthest away (i.e., longest direct flight). Show the name of the origincity, destination city, and the flight time between them  -- Qb. Find all origin cities that only serve flights shorter than 3 hours.List each city only once in the result.   -- Qb. Find all origin cities that only serve flights shorter than 3 hours.Lis ...[Show More]

Preview 1 out of 3 pages
Purchase this document to unlock the blurred part and the rest of the document

Unlock Now

Reviews( 0 )