SELECT
ad_id ,ifnull(round((**sum(action=‘clicked’)/sum(action<>‘Ignored’)***100),2),0) ctr
FROM
Ads
GROUP BY
ad_id
ORDER BY
ctr desc,ad_id asc
sql sum里面可以用等于号 and 和or
最新推荐文章于 2022-05-25 21:02:31 发布
SELECT
ad_id ,ifnull(round((**sum(action=‘clicked’)/sum(action<>‘Ignored’)***100),2),0) ctr
FROM
Ads
GROUP BY
ad_id
ORDER BY
ctr desc,ad_id asc