Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- DATE_FORMAT(o.DATE_INSERT,'%H:00') as TIME,
- COUNT(*) as CNT
- from
- b_sale_order o
- left join b_sale_basket b on b.ORDER_ID = o.ID
- where 1=1
- and b.ID is NULL
- group by TIME
- order by TIME ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement