contribs after a year

SQL

SELECT * 
FROM (
  SELECT COUNT(no_c.user_name) AS no_contribs
  FROM user AS no_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = 0
) AS no_contribs, 
(
  SELECT COUNT(low_c.user_name) AS low_contribs
  FROM user AS low_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = BETWEEN 0 AND 499
) AS low_contribs, 
(
  SELECT COUNT(medium_c.user_name) AS medium_contribs
  FROM user AS medium_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH)  
  AND user_editcount = BETWEEN 500 AND 4999
) AS low_contribs, 

(
  SELECT COUNT(high_c.user_name) AS high_contribs
  FROM user AS high_c
  WHERE  user_registration 
  BETWEEN (NOW() - INTERVAL 12 MONTH) AND (NOW() - INTERVAL 11 MONTH) 
  AND user_editcount > 5000
) AS high_contribs;
SQL

Checking query status...
