摘要: leetcode 1084 销售分析III select distinct p.product_id, p.product_name from Product p left join Sales s on p.product_id = s.product_id where s.product_id 阅读全文
posted @ 2023-05-11 17:59 Carl_ZhangJH 阅读(18) 评论(0) 推荐(0)
摘要: leetcode 1050 合作过至少三次的演员和导演 select actor_id, director_id from ActorDirector group by actor_id, director_id having count(*) >= 3 == 阅读全文
posted @ 2023-05-11 17:23 Carl_ZhangJH 阅读(18) 评论(0) 推荐(0)
摘要: leetcode 1045 买下所有产品的客户 select customer_id from Customer c left join Product p on c.product_key = p.product_key group by customer_id having count(dist 阅读全文
posted @ 2023-05-11 17:05 Carl_ZhangJH 阅读(13) 评论(0) 推荐(0)