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 avg(rating.stars) avgR
FROM rating
GROUP BY mid
ORDER B' at line 6