How to use a avg expression in the WHERE between clause?
Can you try this instead? Instead of having it in the WHERE clause, use it in HAVING clause.

SELECT u.id, AVG(rating_value) avg_rate
FROM dt_tutor_comments u
GROUP by u.id
HAVING AVG(rating_value) BETWEEN 1 AND 2