This will get you the order count, grouped by Order Type, in date range shown.
It queries the Consolidate OE View table, so you get open and invoiced orders.
SELECT COUNT(ord_no) AS ord_count, ord_type
FROM OEINQORD_SQL
WHERE (ord_dt >= 20120101) AND (ord_dt <= 20120531)
GROUP...