Export As Notebook
Automate Export Multiple Tabs to Jupyter Notebook.
Tab 1
Tab 2
Tab 3
Tab 4
Tab 5
Tab 1
Tab 2
Tab 3
Tab 4
Tab 5
Generated SQL
SELECT payment_type, COUNT(*) AS trip_count FROM sample_data. nyc.taxi GROUP BY payment_type ORDER BY trip_count DESC LIMIT 20000;
Query Description
Counts the number of trips for each payment type.
Table Data
Table Data
payment_type
⋮
trip_count
⋮
1
2483550
payment_type
⋮
trip_count
⋮
1
2483550
2
598081
0
121958
4
31334
3
17793
5
1
Plot
Generated SQL
SELECT CAST(tpep_pickup_datetime AS DATE) AS x, COUNT(*) AS y FROM sample_data.nyc.taxi GROUP BY x ORDER BY x LIMIT 20000;
Query Description
Counts the number of trips per day based on the pickup datetime and formats the data for line plot.
Table Data
Table Data
x
⋮
y
⋮
2022-10-31
120506
x
⋮
y
⋮
2022-10-31
34
2022-11-01
120506
2022-11-02
126271
2022-11-03
131484
2022-11-04
130682
2022-11-05
130401
2022-11-06
104570
2022-11-07
112135
2022-11-08
121121
2022-11-09
128700
2022-11-10
132727
2022-11-11
117728
2022-11-12
130944
2022-11-13
114269
2022-11-14
82278
2022-11-15
90728
2022-11-16
92660
2022-11-17
95344
2022-11-18
95454
2022-11-19
94932
2022-11-20
81125
2022-11-21
108526
2022-11-22
114546
2022-11-23
105640
2022-11-24
69663
2022-11-25
86607
2022-11-26
99513
2022-11-27
90529
2022-11-28
106488
2022-11-29
119372
2022-11-30
117677
2022-12-01
57
Plot
Generated SQL
SELECT CASE WHEN trip_distance < 1 THEN 1 WHEN trip_distance < 2 THEN 2 WHEN trip_distance < 3 THEN 3 WHEN trip_distance < 4 THEN 4 WHEN trip_distance < 5 THEN 5 WHEN trip_distance < 10 THEN 6 WHEN trip_distance < 20 THEN 7 WHEN trip_distance < 30 THEN 8 WHEN trip_distance < 40 THEN 9 WHEN trip_distance < 50 THEN 10 ELSE 11 END AS bin_id, COUNT(*) AS frequency FROM sample_data.nyc.taxi WHERE trip_distance < 100 GROUP BY bin_id ORDER BY bin_id;
Query Description
Retrieves the frequency of trips within specified distance bins for the first 1000 rows using CASE statements.
Table Data
Table Data
bin_id
⋮
frequency
⋮
10
1043642
bin_id
⋮
frequency
⋮
1
667647
2
1043642
3
547827
4
268437
5
140938
6
296746
7
251072
8
34069
9
1547
10
355
11
303
Plot
Generated SQL
SELECT RatecodeID, COUNT(*) AS trip_count FROM sample_data.nyc.taxi GROUP BY RatecodeID ORDER BY trip_count DESC LIMIT 20000;
Query Description
Counts the number of trips for each RatecodeID.
Table Data
Table Data
RatecodeID
⋮
trip_count
⋮
percentage
⋮
null
2945260
0.0006456141127555825
RatecodeID
⋮
trip_count
⋮
percentage
⋮
1
2945260
90.54768674926224
2
132584
4.076100072646959
null
121958
3.7494193315926347
5
31064
0.9550169904114006
3
9026
0.27749109436818514
99
8797
0.2704508261862314
4
4007
0.1231893214196009
6
21
0.0006456141127555825
Plot
Generated SQL
SELECT VendorID AS x, AVG(tip_amount) AS y FROM sample_data. nyc.taxi GROUP BY VendorID ORDER BY y DESC LIMIT 20;
Query Description
Calculates the average tip_amount for each VendorID and orders the results by the average tip amount in descending order, limiting to the top 20 VendorIDs.
Table Data
Table Data
x
⋮
y
⋮
2
2.929572542537025
x
⋮
y
⋮
2
2.929572542537025
1
2.579547053346901
6
0
Plot
Export as Notebook
Click on the File Size Below 👇 to Download Notebook
