SELECT count(oi.ordernum) order_count FROM orderinfo oi WHERE