我有一张这样的table

TIME  |STRCOUNTRY |STROPERATOR | NINCOMINGCALLS
300718|RUSSIA     |MTS         | 2
300718|RUSSIA     |Megafon     | 3
300718|UK         |Vodafone    | 1
300718|UK         |UKTele      | 3

这就是我想展示的结尾：呼叫接线员，按国家列出的所有接线员的总和

RUSSIA  |Megafon |  3
RUSSIA  |MTS     |  2
RUSSIA  |#       |  5
UK      |Vodafone|  1
UK      |UKTele  |  3
UK      |#       |  4

# | #      | 9

可以通过这样的查询接收

select * from TM_COMMON_STAT where strCountry = "RUSSIA" and TIME = "300718"

UNION

select STRCOUNTRY, '#' as STROPERATOR, SUM(NINCOMINGCALLS) as 'NINCOMINGCALLS' from TM_COMMON_STAT where strCountry = "RUSSIA" and TIME = "300718"

如何获得表中所有运算符（distinct strcountry+stroperator）的输出，并最终获得所有国家/地区（其中运算符=#）的最终总和？
谢谢你的帮助。