How to use a avg expression in the WHERE between clause? I want to compare two value with avg rating of user  

select * from dt_tutor_comments where avg(rating_value) BETWEEN 1 and 2 GROUP by u.id
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