odbtools/odbctest/mql/uino/401.groupby和orderby.mql

SELECT t1.dept AS "部门", t1.staff_name AS "员工姓名", count(t1.case_id) AS "解决CASE数量" FROM /temp01 t1 GROUP BY t1.dept, t1."员工姓名" ORDER BY t1."解决CASE数量" DESC
/**
output()
**/
;