Compare total rentals by year

#1 · 1 of 5Free sample

Exercises (5)

Instructions

The day table has one row per date. yr is 0 for 2011 and 1 for 2012.

Return two columns: year (2011 or 2012) and total_rentals (the sum of cnt). Order by year.

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