SELECT
cname,
oid,
pname,
odate
FROM
customer,
product,
orders
WHERE
product.pname='iPhone 6s'
AND product.pid = orders.pid
AND orders.cid = customer.cid
AND orders.odate > '2016-11-30'
AND orders.odate < '2017-01-01';
版权声明：本文为weixin_43939570原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。