littlebob

摘要： 这道题的难点在于求差值，因为这道题比较特殊 假设只有这两种水果 那 select sale_date, sum(if(fruit='apples', 1, -1)*sold_num) as diff from `Sales` group by sale_date order by sale_date 阅读全文