You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select rating.mid,avg(rating.stars) as 'AVG' from rating group by rating.mid) a' at line 2