datalakeexample9.sql

select
    (
        select
            sum("passenger_count")
        from
            YELLOW_TAXI_JANUARY_2022_LOADED
        where
            "tpep_pickup_datetime"::time > '1:00am'
            and "tpep_pickup_datetime"::time < '6:00am') as "overnight passengers 2022",
    (
        select
            sum("passenger_count")
        from
            YELLOW_TAXI_JANUARY_2021
        where
            "tpep_pickup_datetime"::time > '1:00am'
            and "tpep_pickup_datetime"::time < '6:00am') as "overnight passengers 2021";

overnight passengers 2022 | overnight passengers 2021 
 -------------------------+-------------------------
 163058                   | 33469
(1 row)