-- Database schema
| Movie : mID [ INT ] primary_key , title [ TEXT ] , year [ INT ] , director [ TEXT ] | Reviewer : rID [ INT ] primary_key , name [ TEXT ] | Rating : rID [ INT ] Rating.rID = Reviewer.rID , mID [ INT ] Rating.mID = Movie.mID , stars [ INT ] , ratingDate [ TEXT ] |
-- -- Return reviewer name, movie title, stars, and ratingDate. And sort the data first by reviewer name, then by movie title, and lastly by number of stars.

SELECT T3.name ,  T2.title ,  T1.stars ,  T1.ratingDate FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID  =  T2.mID JOIN Reviewer AS T3 ON T1.rID  =  T3.rID ORDER BY T3.name ,  T2.title ,  T1.stars;