count then using multiple HAVING not working

[newbeee]

SELECT `submittedby`, COUNT(*) AS postCount FROM `sites` WHERE `confirmed` = '1' GROUP BY `submittedby` HAVING postCount BETWEEN 90 AND 110 OR HAVING postCount BETWEEN 100 AND 1110

 

i have tried a few ways by adding brackets and can not work this out myself.  what is the correct way to use many HAVING..?

[Gamic]

SELECT 
`submittedby`, 
COUNT(*) AS postCount 
FROM `sites` 
WHERE 
`confirmed` = '1' 
GROUP BY `submittedby` 
HAVING postCount BETWEEN 90 AND 1110 

(90<110<1110). You only need one condition for this particular count.

For conditions that don't completly overlap though you would do something like this:

SELECT 
`submittedby`, 
COUNT(*) AS postCount 
FROM `sites` 
WHERE 
`confirmed` = '1' 
GROUP BY `submittedby` 
HAVING (postCount BETWEEN 90 AND 1110) 
OR (postCount between 2000 AND 2099) 
[code]