SELECT count( distinct type + STR(ORDER_NO,10) ) as NUM_ORDS 
FROM mytable 
group by EMPLOYEE

SELECT type, count( distinct ORDER_NO ) as NUM_ORDS 
FROM mytable 
group by EMPLOYEE, type