Find the commute peak hours

#4 · 4 of 5Free sample

Exercises (5)

Instructions

Using the hour table, find the three hours of the day with the highest average rentals on working days.

Return two columns: hr and avg_rentals rounded to 1 decimal. Order by avg_rentals from highest to lowest and return 3 rows.

Loading the practice editor and dataset…

Tables

2 tables · 33 columns

hour17 cols

instantINTEGER PRIMARY KEY
dtedayTEXT NOT NULL
seasonINTEGER NOT NULL
yrINTEGER NOT NULL
mnthINTEGER NOT NULL
hrINTEGER NOT NULL
holidayINTEGER NOT NULL
weekdayINTEGER NOT NULL
workingdayINTEGER NOT NULL
weathersitINTEGER NOT NULL
tempREAL NOT NULL
atempREAL NOT NULL
humREAL NOT NULL
windspeedREAL NOT NULL
casualINTEGER NOT NULL
registeredINTEGER NOT NULL
cntINTEGER NOT NULL

day16 cols

instantINTEGER PRIMARY KEY
dtedayTEXT NOT NULL
seasonINTEGER NOT NULL
yrINTEGER NOT NULL
mnthINTEGER NOT NULL
holidayINTEGER NOT NULL
weekdayINTEGER NOT NULL
workingdayINTEGER NOT NULL
weathersitINTEGER NOT NULL
tempREAL NOT NULL
atemp

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

REAL NOT NULL

humREAL NOT NULL

windspeedREAL NOT NULL

casualINTEGER NOT NULL

registeredINTEGER NOT NULL

cntINTEGER NOT NULL