共享和签名查询

jdg4fx2g 于 2021-07-29 发布在 Java

关注(0)|答案(1)|浏览(280)

有多少份股份和签名（一直）来自以下签名桶内的请愿书：1-499500-999，1000+。
注意：如果请愿书没有签名，则不能共享
table：

目前拥有并接受任何反馈：

SELECT 
  CASE
    WHEN COUNT(DISTINCT t1.petition_id) < 500 THEN '1-499'
    WHEN COUNT(DISTINCT t1.petition_id) >= 500 AND COUNT(DISTINCT t1.petition_id) < 1000 THEN '500-999'
    ELSE '1000+' END AS Signature_Buckets
FROM 
  signatures t1
LEFT JOIN 
  shares t2
ON 
  t1.petition_id ON t2.petition_id

sql

来源：https://stackoverflow.com/questions/62335272/shares-and-signatures-query

1条答案

按热度按时间

jjhzyzn01#

这个案子的解释还不完全清楚。几行样本数据可能有助于澄清边境案件。不过，下面的查询似乎会返回所需的结果：

select
  bucket,
  count(*) as signatures,
  sum(shares) as total_shares
from (
  select 
    s.petition_id,
    count(h.petition_id) as shares,
    case when count(h.petition_id) < 500 then '1-499'
         when count(h.petition_id) < 1000 then '500-999'
         else '1000+' 
    end as bucket
  from signatures s
  left join shares h on h.petition_id = s.petition_id
  group by s.petition_id
  having count(h.petition_id) > 1
) x

展开查看全部

赞(0）回复(0）举报 2021-07-29

我来回答

共享和签名查询

1条答案

相关问题

热门标签

最新问答