SELECT
pname, SUM(ocount)
FROM
product,
orders
WHERE
product.pid = orders.pid
AND product.pname = '小米Note2'
AND orders.odate > '2016-11-30'
AND orders.odate < '2017-01-01';
2. 查询小米Note2 2016年12月份共买了多少台。显示产品名称，买的台数
SELECT
pname, SUM(ocount)
FROM
product,
orders
WHERE
product.pid = orders.pid
AND product.pname = '小米Note2'
AND orders.odate > '2016-11-30'
AND orders.odate < '2017-01-01';
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
