with e as (select a.用户,a.角色,b.权限1 from HD_test2 a join HD_test1 b on a.角色=b.角色),f as (select e.角色,e.用户,d.城市,case when d.城市 like '%集团%' then '1'case d.城市 like '%物业公司%' then '2'case d.城市 like '%恒大%' then '3' else '0'end as 'A',d.指标,d.金额,d.类别 from 经营云南多指标 d left join e on 权限1=d.城市where 指标='1-7月累计收入' and e.用户='${fr_username}' ${if(len(province2)=0||province2 = '集团',"and 城市='集团'","and 城市='"+province2+"'")})select *from f where A=(select min(A) from f) 这个sql用子查询怎么写,