Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select count(s1.order_id)
- from sales_sale s1
- full outer join sales_saleitem s2 on s2.order_id=s1.id
- WHERE (s1.date_created > current_date - interval '60' day) - (s1.date_created > current_date - interval '30' day )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement