How to make a mysql query, output by month 2 values?

Question

MySQL

There is a status field (0,1) there is a creation date field, you need to make a selection from the entire database by months with the number of status 1 and status 0

SELECT month(reviews.rev_create) as mn , count(reviews.status) as one FROM reviews GROUP BY month(reviews.rev_create), reviews.status;

it turns out but not in one line, but it is necessary in one, help)

Answer 1

?

SELECT 
    month(reviews.rev_create) as mn, 
    count(IF(reviews.status = 1, 1, NULL)) as positive, 
    count(IF(reviews.status = 0, 1, NULL)) as negative
FROM 
    reviews 
GROUP BY mn