考察了基础语法与 排序窗口函数

select 
     product_id
    ,product_name
    ,total_sales_amount
    ,total_sales_quantity
from(
        select
             pd.product_id
            ,pd.product_name
            ,sum(sales_amount)   as total_sales_amount
            ,sum(sales_quantity) as total_sales_quantity
            ,dense_rank()over(order by sum(sales_quantity) desc) as rk
        from 
            products as pd left join sales_records as sr 
            on pd.product_id = sr.product_id
        where 
            sales_date between "2024-01-01" AND "2024-12-31"
        group by 
            pd.product_id,pd.product_name
	) t1
where rk = 1
order by product_id asc