Skip to content

Instantly share code, notes, and snippets.

@mderoy

mderoy/datalakeexample8.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/b35afe2dfc702f8b924cc098939ae278 to your computer and use it in GitHub Desktop.
Save mderoy/b35afe2dfc702f8b924cc098939ae278 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
datalakeexample8.sql
select
(
select
sum("passenger_count")
from
YELLOW_TAXI_JANUARY_2022_LOADED) as "passengers 2022",
(
select
sum("passenger_count")
from
YELLOW_TAXI_JANUARY_2021) as "passengers 2021";
passengers 2022 | passengers 2021 
 - - - - - - - --------+ - - ----- - - - - -----
 3324167 | 1794615
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment