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 '1
SELECT m.title as title, t1.avg_movie as avg_rating
2
FROM (SELECT mID, AVG' at line 1