Database: movie_1
Question: For each reviewer id, what is the title and rating for the movie with the smallest rating?
SQL:
SELECT T2.title ,  T1.rID ,  T1.stars ,  min(T1.stars) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID  =  T2.mID GROUP BY T1.rID