34,837
社区成员




SELECT SUM(SaleNum) ,
CAST(SaleDate AS DATE) AS SaleDate ,
GoodsId
FROM SaleItem
GROUP BY CAST(SaleDate AS DATE) ,
GoodsId
ORDER BY CAST(SaleDate AS DATE) ,
SUM(SaleNum) DESC;
SELECT *
FROM Stock AS a
INNER JOIN Goods AS b ON a.GoodsId = b.GoodsId
SELECT *
FROM Stock AS a
INNER JOIN Goods AS b ON a.GoodsId = b.GoodsId
WHERE NOT EXISTS ( SELECT 1
FROM SaleItem
WHERE GoodsId = a.GoodsId );