- 原题题目
- 代码实现（首刷自解）
原题题目
代码实现（首刷自解）
# Write your MySQL query statement below SELECt s1.sale_date,(s1.sold_num - s2.sold_num) diff FROM sales s1 INNER JOIN sales s2 ON s1.sale_date = s2.sale_date WHERe s1.fruit = 'apples' and s2.fruit = 'oranges' ORDER BY sale_date
