LeetCode-SQL-1159. 市场分析 II

SELECT
    Users.user_id AS 'seller_id',
    if(O3.item_id is not null AND Users.favorite_brand=Items.item_brand,'yes','no') AS '2nd_item_fav_brand' 
FROM
    Users
    LEFT JOIN
    (
        SELECT seller_id,(
                            SELECT 
                                item_id
                            FROM
                                Orders O2
                            WHERE
                                O2.seller_id=O1.seller_id
                            ORDER BY order_date LIMIT 1,1
                         ) AS 'item_id'
        FROM
            Orders O1
        GROUP BY seller_id
    ) O3
    ON Users.user_id=O3.seller_id
    LEFT JOIN
    Items
    ON O3.item_id=Items.item_id

作者：nojoker
链接：https://leetcode-cn.com/problems/market-analysis-ii/solution/left-join-limit-11jian-dan-zhi-guan-by-nojoker/
来源：力扣（LeetCode）
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。