SQL横向添加

select t.customer, count(t.customer)
  from tablea t
 where t.phoneno in ('777777', '222222')
 group by t.customer order by t.customer;
 
 
 select t.customer, count(t.customer)
  from tablea t
 where t.phoneno = '777777'
 group by t.customer order by t.customer;
 
 select t.customer, count(t.customer)
  from tablea t
 where t.phoneno = '222222'
 group by t.customer order by t.customer;
 
 
 
select C.*,nvl(D.count_2,0)
  from (select A.customer, A.count, B.count_7
          from (select t.customer, count(t.customer) as count
                  from tablea t
                 where t.phoneno in ('777777', '222222')
                 group by t.customer
                 order by t.customer) A
          left join (select t.customer, count(t.customer) as count_7
                      from tablea t
                     where t.phoneno = '777777'
                     group by t.customer
                     order by t.customer) B on A.customer = B.customer) C
  left join (select t.customer, count(t.customer) as count_2
               from tablea t
              where t.phoneno = '222222'
              group by t.customer
              order by t.customer) D on C.customer = D.customer