Advertisement

1445. Apples & Oranges

SQL

SELECT
  sale_date,
  SUM(IF(fruit = 'apples', sold_num, -sold_num)) AS diff
FROM Sales
GROUP BY 1;

Advertisement