Hi, I need help with a sql statement. Suppose I have a table movies(movie_title, movie_rating, date_rated, user) and I want to find the highest ranked movies for each user. Rather than write several sql statements, I'd like perform this query in a single nested sql statement. Does anyone know how to do that?
