阅读背景:

Ansi SQL查询给出了不合理的结果

来源:互联网 
SELECT 
count(added_to_cart=1 ) AS all_addtocart,
count(added_to_cart =1 AND purchased IS NULL) AS abandonment
FROM emr_data 
WHERE y='2017' AND m= '01'
ORDER BY count(*) DESC
SELECT 
count(added_to_cart=1 ) AS all_addtocar



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: