query07.sql

/*
    How many trips started on one day and ended on a different day?

    Your result should have one column named trip_year, one column named
    trip_quarter, and one column named num_trips.
*/

select
    2021 as trip_year,
    3 as trip_quarter,
    count(*) as num_trips
from indego.trips_2021_q3
where start_time::date != end_time::date

union all

select
    2022 as trip_year,
    3 as trip_quarter,
    count(*) as num_trips
from indego.trips_2022_q3
where start_time::date != end_time::date

/*
    Hint 1: when you cast a TIMESTAMP to a DATE the time component of the value is stripped off.

    Hint 2: Years, quarters, and other parts of DATEs or TIMESTAMPs can be retrieved using the
    [EXTRACT](https://www.postgresql.org/docs/12/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT)
    function.
*/