加入哪些行不存在或哪里标准匹配......？

I'm trying to write a query to tell me which orders have valid promocodes. Promocodes are only valid between certain dates and I'm trying to write a query to tell me which or