How to make a SQL-query for getting titles only with their maximum rating from this table? SQL-table

CodePudding user response：

I'm guessing that this will work

SELECT title, MAX(stars) FROM table GROUP BY title