An HQL statement

0 comments

Problem statement 8:

Write an HQL statement to list all flights whose departure delay time is greater than the average departure delay time and show how much their delay time is greater than the average. Hint use a subquery with an aggregate function.

The dataset consists of 8 columns and their respective description is as follows:

Day of Month

The specified day of the month

Day of Week

The specified day of the week

Reporting Carrier

Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.

Origin

Origin Airport

Dest

Destination Airport

Departure Delay Minutes

Difference in minutes between scheduled and actual departure time. Early departures set to 0.

Arrival Delay Minutes

Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.

Weather Delay

Weather delay in minutes

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}