https://leetcode-cn.com/problems/market-analysis-ii/
1159.pngselect u.user_id seller_id,case when u.favorite_brand=i.item_brand then 'yes' else 'no' end 2nd_item_fav_brand
from
(select user_id,favorite_brand from Users )u left join
(
select a.seller_id,i.item_brand
from(
select a.seller_id,sum(case when a.rn=2 then a.item_id end) item_id
from(
select row_number() over(partition by seller_id order by order_date) rn ,seller_id ,item_id
from Orders
)a group by a.seller_id
)a left join Items i on a.item_id=i.item_id
)i on u.user_id=i.seller_id
网友评论