MySQL将确定的值作为数据行查询出来

select
    sjrq as dictDate,
       (select
               (case when bqnr >0  and bqnr <=10  then '(0,10]'
                     when bqnr >10  and bqnr <=20  then '(10,20]'
                     when bqnr >20  and bqnr <=30  then '(20,30]'
                     when bqnr >30  and bqnr <=40  then '(30,40]'
                     when bqnr >40  and bqnr <=50  then '(40,50]'
                     when bqnr >50  and bqnr <=60  then '(50,60]'
                     when bqnr >60  and bqnr <=70  then '(60,70]'
                     when bqnr >70  and bqnr <=80  then '(70,80]'
                     when bqnr >80  and bqnr <=90  then '(80,90]'
                     when bqnr >90  and bqnr <=100  then '(90,100]'
                     end)
       ) as 'dictName',
       sum(bqnr) as dictCount
from lijiankuntest
GROUP BY sjrq,dictName