已知商品订单表 product_orders 数据：
|----------|--------|---------------------------|
|orderId| num | products |
|order1 | 10 |soap,toothpaste |
|order2 | 15 |toothpaste,shampoo|
|order3 | 20 |soap,shampoo |
|---------|---------|---------------------------|
下列查询每个商品按照订单数量排名的语句哪个是正确的（）
Aselect product,orderId,num,dense_rank() over (partition by product order by num) as rank from product_orders lateral view explode(split(products,',')) tmp as product;
Bselect product,orderId,num,dense_rank() over (partition by product order by num) as rank from product_orders lateral view explode(products) tmp as product;
Cselect product,orderId,num,dense_rank() over (order by num) as rank from product_orders lateral view explode(split(products,',')) tmp as product;
Dselect product,orderId,num,dense_rank() over (partition by product ) as rank from product_orders lateral view explode(split(products,',')) tmp as product;