SELECT article_id,COUNT(article_like = 1 or null) AS like_count,
COUNT(article_like = 2 or null) AS dislike_count
FROM ...
count 中放入条件,为真则计一次,为假则为 null 不计数
SELECT article_id,COUNT(article_like = 1 or null) AS like_count,
COUNT(article_like = 2 or null) AS dislike_count
FROM ...
count 中放入条件,为真则计一次,为假则为 null 不计数