美文网首页
Leetcode 1159. 市场分析 II

Leetcode 1159. 市场分析 II

作者: 七齐起器 | 来源:发表于2021-11-27 17:27 被阅读0次

https://leetcode-cn.com/problems/market-analysis-ii/

1159.png
select 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 

相关文章

网友评论

      本文标题:Leetcode 1159. 市场分析 II

      本文链接:https://www.haomeiwen.com/subject/tontxrtx.html