Skip to content

Instantly share code, notes, and snippets.

@mderoy

mderoy/datalakeexample4.sql Secret

Last active August 1, 2022 12:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mderoy/f19ec791ff84ed2b454021c7842a798f to your computer and use it in GitHub Desktop.
Save mderoy/f19ec791ff84ed2b454021c7842a798f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
datalakeexample4.sql
select
"VendorID",
sum("passenger_count") as "passengers"
from
YELLOW_TAXI_JANUARY_2022
where
"tpep_pickup_datetime"::time > '1:00am'
and "tpep_pickup_datetime"::time < '6:00am'
group by
"VendorID"
order by
"passengers" desc;
VendorID | passengers 
 - - - - - ---+ - - --- - - - 
 2 | 122251
 1 | 40807
 6 | 
 5 | 
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment