使用条件聚合：

select
    assigned_analyst,
    sum(case when status = 'Past Due' then 1 else 0 end) past_due,
    sum(case when status = 'Due within 3 Months' then 1 else 0 end) due_3_month
from mytable
group by assigned_analyst

要获得基于每个分析师和状态的发行人/股票发行人计数，请尝试以下操作：

SELECT
    [Assigned Analyst]
    ,[Status]
    COUNT(distinct [Issuer/Ticker]) [Count of Issuer/Ticker]
FROM TableName
GROUP BY [Assigned Analyst], [Status]

否则，要仅获取allison shenoy的计数，请尝试以下操作：

SELECT
    [Status]
    COUNT(distinct [Issuer/Ticker]) [Count of Issuer/Ticker]
FROM TableName
WHERE [Assigned Analyst] = 'Allison Shenoy'
GROUP BY [Status]

显然，用表的实际名称替换“tablename”