Report not found

There was a problem finding this report.
SQL/Python Hybrid - GroupBy
February 5, 2018 · Refreshed 5 months ago

Collaborators

Run History
select bst.start_station_name, bst.end_station_name, count(1) as num_trips, avg(duration) as avg_duration_seconds, min(duration) as min_duration_seconds, max(duration) as max_duration_seconds from modeanalytics.sf_bike_share_trip bst group by 1,2 having count(1) > 1000
select bst.start_station_name, bst.end_station_name, count(1) as num_trips, avg(duration) as avg_duration_seconds, min(duration) as min_duration_seconds, max(duration) as max_duration_seconds from modeanalytics.sf_bike_share_trip bst group by 1,2 having count(1) > 1000
select bst.id as trip_id, bst.start_station_name, bst.end_station_name, bst.duration as trip_duration_seconds from modeanalytics.sf_bike_share_trip bst
select bst.id as trip_id, bst.start_station_name, bst.end_station_name, bst.duration as trip_duration_seconds from modeanalytics.sf_bike_share_trip bst
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled