我在 ORACLE 的同一个查询中需要 2 个计数列

这是一种选择；它不使用count，但sum有case表达。

样本数据：

SQL> with
  2  invoice (id, amount, comp_sending, comp_receiving) as
  3    (select 1, 2000 , 1, 2 from dual union all
  4     select 2, 28250, 3, 2 from dual union all
  5     select 3, 8700 , 4, 1 from dual union all
  6     select 4, 20200, 5, 3 from dual union all
  7     select 5, 21500, 3, 4 from dual
  8    ),
  9  company (id, name, city, state) as
 10    (select 1, 'Microsoft', 'Redmond'  , 'Washington' from dual union all
 11     select 2, 'Ubisoft'  , 'Paris'    , 'France'     from dual union all
 12     select 4, 'Starbucks', 'Seattle'  , 'Washington' from dual union all
 13     select 5, 'Apple'    , 'Cupertino', 'California' from dual union all
 14     select 3, 'Nvidia'   , 'Cupertino', 'California' from dual
 15    )

查询从这里开始：

 16  select c.id, c.name,
 17    sum(case when c.id = i.comp_sending   then 1 else 0 end) cnt_sent,
 18    sum(case when c.id = i.comp_receiving then 1 else 0 end) cnt_received
 19  from company c left join invoice i on c.id in (i.comp_sending, i.comp_receiving)
 20  group by c.id, c.name
 21  order by c.id;

        ID NAME        CNT_SENT CNT_RECEIVED
---------- --------- ---------- ------------
         1 Microsoft          1            1
         2 Ubisoft            0            2
         3 Nvidia             2            1
         4 Starbucks          1            1
         5 Apple              1            0

SQL>