赞
踩
Leetcode 1068. 产品销售分析 I
关于两个表的信息,要用到连接,左连接、内连接。
# Write your MySQL query statement below select p.product_name, s.year, s.price from Sales as s left join Product as p on s.product_id = p.product_id;