substring(str, pos, len)
SELECT count(id) as total ,substring(identity,1,2) as area FROM `dg_appointment` WHERE `org_id` = 1 GROUP BY area;
substring(str, pos, len)
SELECT count(id) as total ,substring(identity,1,2) as area FROM `dg_appointment` WHERE `org_id` = 1 GROUP BY area;