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…
Loading the workspace…