-- Database schema
| users : userid [ INTEGER ] primary_key , age [ TEXT ] , u_gender [ TEXT ] , occupation [ TEXT ] | directors : directorid [ INTEGER ] primary_key , d_quality [ INTEGER ] , avg_revenue [ INTEGER ] | actors : actorid [ INTEGER ] primary_key , a_gender [ TEXT ] , a_quality [ INTEGER ] | movies : movieid [ INTEGER ] primary_key , year [ INTEGER ] , isEnglish [ TEXT ] , country [ TEXT ] , runningtime [ INTEGER ] | movies2actors : movieid [ INTEGER ] , actorid [ INTEGER ] , cast_num [ INTEGER ] | movies2directors : movieid [ INTEGER ] , directorid [ INTEGER ] , genre [ TEXT ] | u2base : userid [ INTEGER ] , movieid [ INTEGER ] , rating [ TEXT ] |
-- -- List the top 10 USA movies, by descending order, from the highest to the lowest, the user rating.

SELECT T1.movieid FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'USA' GROUP BY T1.movieid ORDER BY AVG(T1.rating) DESC LIMIT 10;