select * from accu_air t where t.accu_date BETWEEN 20211009 and 20211009 and regexp_like(coupon_no, '\D')