This SQL result is error. SELECT COUNT(DISTINCT VIEW_TAXI_RIDE.PASSENGER_ID) FROM VIEW_TAXI_RIDE WHERE VIEW_TAXI_RIDE.create_day = '2018-04-10' AND VIEW_TAXI_RIDE.STATUS IN (6,7) AND VIEW_TAXI_RIDE.PASSENGER_ID IN ( SELECT DISTINCT v.PASSENGER_ID FROM view_taxi_ride v WHERE v.create_day = '2018-04-11' AND v.STATUS IN (6,7) )
Bug this SQL result is right. select intersect_count(passenger_id, create_day, array['2018-04-10','2018-04-11']) from VIEW_TAXI_RIDE where STATUS IN (6,7)
