以CAP表作为练习的对象,顾客customers,代理商agents,和商品products,订单表orders为例子


Get the names of customers who order at least one product priced at $0.50.
1.查询所有订购了至少一个价值为0.5的商品的客户名字
答案在2.7.8
版权声明:本文为qq_41166909原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。
以CAP表作为练习的对象,顾客customers,代理商agents,和商品products,订单表orders为例子


Get the names of customers who order at least one product priced at $0.50.
1.查询所有订购了至少一个价值为0.5的商品的客户名字
答案在2.7.8