Compare casual rider share on working days

#3 · 3 of 5Free sample

Exercises (5)

Instructions

Casual riders behave differently from registered commuters. For working days and non-working days (workingday = 1 or 0), calculate the share of rentals from casual riders.

Return three columns: day_type (working_day or ), , and rounded to 1 decimal. Order by .

non_working_day

total_rentals

casual_share_pct

day_type

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