Find the biggest month-over-month increases

#5 · 5 of 5Free sample

Exercises (5)

Instructions

Build monthly rental totals across both years, compare each month with the previous month, and find the three largest percentage increases.

Return four columns: month in YYYY-MM format, rentals, previous_rentals, and growth_pct rounded to 1 decimal. Order by growth_pct 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