explain select * from trips where pickup_datetime > dateadd('m', -1, now()) order by pickup_datetime desc 
DataFrame
    Row backward scan
    Interval backward scan on: trips
      intervals: [static=[0,9223372036854775807,281481419161601,4294967296] dynamic=[dateadd('m',-1,now())]]

explain select * from trips desc limit -10
Sort light
  keys: [ts]
    Limit lo: 5
        DataFrame
            Row backward scan
            Frame backward scan on: trips

explain select * from trips where passenger_count > 0 order by pickup_datetime desc limit -10 ;

Async JIT Filter
  limit: 10
  filter: 0<passenger_count
  workers: 14
    DataFrame
        Row forward scan
        Frame forward scan on: trips

select distinct passenger_count from trips where passenger_count < 5 limit 10
select distinct pickup_datetime from trips where passenger_count < 5 limit 10

Limit lo: 10
    DistinctTimeSeries
      keys: pickup_datetime
        SelectedRecord
            Async JIT Filter
              limit: 10 <-- WRONG
...

select * from 
(select * from trips order by pickup_datetime asc, passenger_count limit 10) 
lt join 
(select * from trips) order by pickup_datetime asc

explain select * from (select * from trips order by pickup_datetime desc) t1 cross join trips t2 order by t1.pickup_datetime
SelectedRecord
    Cross Join
        DataFrame
            Row forward scan
            Frame forward scan on: trips
        DataFrame
            Row forward scan
            Frame forward scan on: trips