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_addtocarSELECT
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