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