am creating report module based on dispatched order and pending order my question is in SQL
1.How to add "where" clause ,2. How to find Deliver product order in presta shop table in db , 3. i was written where condition for current date and yesterday in controller its not working anybody pls suggest my queries .