两个表中，一个表中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'
)
k
left join
(
select left(HY_TYPE, 1) as hyTypeValue from BI_PROJECT_INFO
)
m
on
m.hyTypeValue = k.DICT_VALUE

group by k.DICT_LABEL
order by value desc
limit 10