select product_id, product_name, total_sales_amount, total_sales_quantity from ( select p.product_id, product_name, sum(sales_amount) total_sales_amount, sum(sales_quantity) total_sales_quantity, rank() over ( order by sum(sales_quantity) desc ) rk from products p join sales_records s on p.product_i...