# Write your MySQL query statement below
SELECT distinct user_id as 'seller_id',
case when favorite_brand = item_brand then 'yes'
else 'no'
end as '2nd_item_fav_brand'
FROM
#用户卖出列表
(select user_id
leetcode 数据库刷题 1159. 市场分析 II
最新推荐文章于 2023-04-03 20:59:10 发布