Sulba
ReviewSign inAccount
Theme
Editor theme
Light
Dark

Intermediate · Data pipelines

Analytical SQL

Answer a cab dispatcher's questions about a month of New York's yellow cab trips in Postgres: each borough's busiest zones with ties kept, an hour-by-hour series with running totals, subtotals by borough and payment, a review of an analyst's report, and a daily summary that a run replaces whole.

You build
zones.py, then hours.py, then payments.py, then report.py, then summary.py
Stages
3 Build, 1 Catch, 1 Ship
Time
About 3 hours
Runs on
Your machine

Loading the workspace…