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