Syntax form test in MySQL course

MySQL syntax.sql

SELECT 
     first_name,
     last_name,
     COUNT(rating)                    AS count,
     IFNULL(MIN(rating),0)            AS min,
     IFNULL(MAX(rating), 0)           AS max,
     ROUND(IFNULL(AVG(rating), 0), 2) AS avg,
CASE
   WHEN COUNT(rating) > 0 THEN 'ACTIVE'
   ELSE 'INACTIVE'
   END                                AS 'STATUS'
FROM reviewers
LEFT JOIN reviews
  ON reviewers.id = reviews.reviewer_id
GROUP BY reviewers.id
ORDER BY rating DESC;