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 'by raing.mid) as rat
on movie.mid = rat.mid
order by rat.ave desc, movie.t' at line 5