Medium
SQL Query Construction
Generate a SQL query to solve a specific data retrieval problem.
📝 Nội dung Prompt
Assume a table named 'Sales' with columns 'id', 'product_name', 'quantity', and 'price'. Write a SQL query to calculate the total revenue (quantity * price) for each product, ordered by the highest revenue first.