擅长:python、mysql、java
<p>如果我没弄错的话,你只需要过去三十天和总数的比率。您可以使用条件聚合来获得它。所以,假设<code>cnt</code>总是大于<code>0</code>:</p>
<pre><code>select d.domain_name,
sum(cnt) as CntTotal,
sum(case when date_of_entry >= date_sub(now(), interval 1 month) then cnt else 0 end) as Cnt30Days,
(sum(case when date_of_entry >= date_sub(now(), interval 1 month) then cnt else 0 end) / sum(cnt)) as Ratio30Days
from domains d
group by d.domain_name
order by Ratio30Days desc;
</code></pre>