两个表中，一个表中DICT_VALUE为A,B,C; 另一个表HY_TYPE为A0101；查询HY_TYPE为A 开头的字段个数。select k.DICT_LABEL as "name", count(m.hyTypeValue) "value"from ( select DICT_VALUE, DICT_TYPE,DICT_LABEL from SYS_DICT_DATA where DICT_TYPE='hy_type' ) kleft join ( select left(HY_TYPE, 1) as hyTypeValue from BI_PROJECT_INFO ) mon m.hyTypeValue = k.DICT_VALUEgroup by k.DICT_LABEL order by value desc limit 10