select *
from (select
c.fname as fbmname ,
d.fname as fempname ,
a.FBILLNO AS FORBILLNO,
e.fname as fcustname ,
e.fnumber as fcustnumber ,
sum(b.FBILLALLAMOUNT_LC)*1/10000 AS Foramount ,
case when LEFT(RIGHT(E.FNUMBER,8),4)>='2024' then '新客户' else '老客户' end as MK
from T_SAL_ORDER a
left join T_SAL_ORDERFIN b on b.fid=a.fid
left join T_BD_DEPARTMENT_L c on c.fdeptid=a.fsaledeptid
left join V_BD_SALESMAN_L d on d.fid=a.fsalerid
left join (select b.fname , a.fnumber ,a.FCUSTID ,a.FCreateDate
from T_BD_CUSTOMER a
left join T_BD_CUSTOMER_L B ON B.Fcustid=A.Fcustid ) e on e.fcustid=a.fcustid
where a.FBILLNO like '%CO%' and e.FNUMBER like '%A%'
group by c.fname , d.fname , a.FBILLNO , e.fname , e.FNUMBER ) AS G
WHERE Foramount > '30'
SELECT
c.fname AS fbmname,
d.fname AS fempname,
a.FBILLNO AS FORBILLNO,
