with t1 as (
    select product_id,sum(sales_amount) total_sales_amount,sum(sales_quantity) total_sales_quantity
    ,rank()over(order by sum(sales_quantity) desc) rk
    from sales_records s 
    where sales_date between '2021-01-01' and '2024-12-31'
    group by product_id 
    order by product_id
)
select t1.product_id,product_name,total_sales_amount,total_sales_quantity
from t1 join products p on t1.product_id = p.product_id
where t1.rk = 1