题解 | 返回购买价格为 10 美元或以上产品的顾客列表
SELECT cust_id
FROM Orders
WHERE order_num IN ( SELECT order_num
FROM OrderItems
WHERE item_price>=10);
IN括号里面不需;
SELECT cust_id
FROM Orders
WHERE order_num IN ( SELECT order_num
FROM OrderItems
WHERE item_price>=10);
IN括号里面不需;
相关推荐
迷茫的大四🐶:这么低干个鸡毛啊,还得交五险一金呢,拿到手压根没多少,还得租房吃饭,说真的,低于8k,真没必要干代码,生活质量都存在问题