同一字段不同查询条件查询结果显示

select y.id, q.name,SUM(q.price) sum_price,
               (select sum(fetch_price)
                from Table1
                where buniess_name like '%业务名%'
                  and q.id = Table1.id) fetch_price_name

              
        from Table1 q
                 inner join Table2 y on q.name = y.name
        group by q.id,q.name, y.id

• 问题：速度慢

2.第二种

select NAME,
           ID,
           sum(case when SERVICE_NAME = ' ' then FEE_SUM else 0.0 end) fetch_price,
           sum(FEE_SUM) sum_price
   from Table1 q
                 inner join Table2 y on q.name = y.name
        group by q.id,q.name, y.id