（2020年原始访问量/2019年原始访问量）*100所以它只有4行，分别是1月，2月，3月，4月。我只是不知道如何实现这一点，因为我想除以的值在同一列中。任何建议都将不胜感激！在此处输入图像描述
3j86kqsm1#
(count(2020 raw visits)/count(2019 raw visits)) * 100group by Column_Month
(count(2020 raw visits)/count(2019 raw visits)) * 100
group by Column_Month
1aaf6o9v2#
SELECT (count(CASE WHEN YEAR=2020 THEN visits ELSE NULL END)/count(CASE WHEN YEAR = 2019 THEN visits ELSE NULL END)) * 100FROM TABLEWHERE YEAR IN(2019,2020)group by Column_Month
SELECT (count(CASE WHEN YEAR=2020 THEN visits ELSE NULL END)/count(CASE WHEN YEAR =
2019 THEN visits ELSE NULL END)) * 100
FROM TABLE
WHERE YEAR IN(2019,2020)
2条答案
按热度按时间3j86kqsm1#
1aaf6o9v2#