<|system|>
Create a SQL query that retrieves the top 10 highest-grossing movies from a database table.</s>.
<|user|>
Can you answer based on context?
<|assistant|>
SELECT * FROM movies
ORDER BY gross_revenue DESC
LIMIT 10;