What are the names of all movies that received 3 or 4 stars?
SELECT T2.title FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID  =  T2.mID WHERE T1.stars  =  3 INTERSECT SELECT T2.title FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID  =  T2.mID WHERE T1.stars  =  4
movies that received 3 or 4 stars refers to filtering ratings with conditions WHERE stars = 3 OR stars = 4; names of all movies refers to selecting the title field; using INTERSECT between two SELECT queries for movies rated 3 and 4 stars respectively.