SELECT
number
, name
, COUNT(*) AS TotalCount
FROM test
WHERE name ='바'
GROUP BY number
HAVING number BETWEEN 2 AND 4