调用IDA 123 >td style="text-align:left；">贷款银行账户A B 900 >td style="text-align:left；">贷款银行账户
with t2 as
(select round(1.0*count(distinct call_id)/count(*), 2) dis_by_calls from t)
select intent_product
,count(*) as Resolved_Count
,count(*)*max(dis_by_calls) as Containment_Count
from t, t2
group by intent_product
having intent_product <> 'request_agent'
| intent_product | resolved_count | containment_count|
|---|---|---|
| 贷款银行账户 | 2 | 0.80|
| 停止支票 | 1 | 0.40 |