What are the titles of all movies that have between 3 and 5 stars?
SELECT T2.title FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID  =  T2.mID WHERE T1.stars BETWEEN 3 AND 5
titles of all movies that have between 3 and 5 stars refers to SELECT title FROM Movie WHERE stars BETWEEN 3 AND 5; joining tables Movie and Rating on movie ID refers to JOIN Movie ON Rating.mID = Movie.mID;