Loading this exercise…

Compare bike-sharing commute demand

#5 · 5 of 5Free sample

Instructions

Compare bike-sharing commute demand

A transportation analyst wants to compare two summer demand patterns in bike_hourly: working days at 08:00 and non-working days at 10:00. Use summer observations only.

Return exactly two columns: segment and avg_rentals rounded to 1 decimal. Label the segments working_day_08 and weekend_10, in that order.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

A free account records your attempt and then reveals the reference answer and the explanation for every exercise in the library.

Reference answer + explanation revealed after each attempt
Progress saved on the platform
1,598 graded exercises
Free forever — no credit card
The GPT tutor is part of the course, not the free tier

Create free account →Already a member? Log in →

All exercises in Free Dataset Analysis

order_dateTEXT NOT NULL

statusTEXT NOT NULL

gross_amountREAL NOT NULL

discount_amountREAL NOT NULL

ecommerce_refunds4 cols

refund_idINTEGER PRIMARY KEY
order_idINTEGER NOT NULL
refund_dateTEXT NOT NULL
refund_amountREAL NOT NULL

subscription_accounts2 cols

account_idINTEGER PRIMARY KEY
started_onTEXT NOT NULL

subscription_events5 cols

event_idINTEGER PRIMARY KEY
account_idINTEGER NOT NULL
event_dateTEXT NOT NULL
event_typeTEXT NOT NULL
plan_mrrREAL NOT NULL

campaign_imports6 cols

import_idINTEGER PRIMARY KEY
campaign_idTEXT
activity_dateTEXT NOT NULL
channelTEXT NOT NULL
spend_usdREAL NOT NULL
conversionsINTEGER NOT NULL

inventory_opening2 cols

product_idINTEGER PRIMARY KEY
opening_unitsINTEGER NOT NULL

inventory_movements5 cols

movement_idINTEGER PRIMARY KEY
product_idINTEGER NOT NULL
movement_dateTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL

bike_hourly6 cols

observation_idINTEGER PRIMARY KEY
ride_dateTEXT NOT NULL
hourINTEGER NOT NULL
working_dayINTEGER NOT NULL
seasonTEXT NOT NULL
rentalsINTEGER NOT NULL

Tables

8 tables

ecommerce_orders6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL