SQL 百分比查询

Question

我是SQL的初学者，我的问题是关于从一个名为merged的表中计算总披露总数的百分比。我想从committee_position中计算"支持"的数量(合并表中的一列(

在这种情况下如何计算百分比。 我从以下方面开始：

SELECT Sum (amount) *100
from merged
where merged.committee_position == 'SUPPORT';

帮我继续，谢谢

Answer 1

如果我正确关注了你，你可以做条件聚合：

select 
100.0 * sum(case when committee_position = 'SUPPORT' then amount else 0 end) / sum(amount)
from merged

这为您提供了committee_position = 'SUPPORT'的金额与表中总金额的百分比。

Answer 2

你去吧。

SELECT a.Support_Amount/b.Total_Amount*100
FROM (SELECT Sum (amount) as Support_Amount
from merged
where merged.committee_position = 'SUPPORT') as a
CROSS JOIN 
(SELECT Sum (amount) as Total_Amount
from merged) as b