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