with rides as (
    select *
    from
        (
            select r.*, row_number() over(partition by id order by updated_at desc) as rn
            from pathao_ride.rides as r
            where created_at >= '2018-01-01'
        )
    where rn = 1
),
ride_assignments as (
    select *
    from
        (
            select r.*, row_number() over(partition by id order by updated_at desc) as rn
            from pathao_ride.ride_assignments as r
            where created_at >= '2018-01-01'
        )
    where rn = 1
),