Unnamed

    SELECT          MOVIES.movieid,        MOVIES.title AS title,        GENRES.genre AS "genre",        RATINGS.votes AS votes,        RATINGS.rank AS rank,        COUNTRIES.country AS country,        Movies.year AS year    FROM         MOVIES        ,GENRES        ,RATINGS        ,COUNTRIES     WHERE         Movies.year > 2001        AND        RATINGS.rank > 6.0        AND        COUNTRIES.country = "USA"        AND        RATINGS.votes > 1000        AND        MOVIES.movieid = GENRES.movieid         AND        MOVIES.movieid = RATINGS.movieid        AND        MOVIES.movieid = COUNTRIES.movieid    GROUP BY MOVIES.title