题解 | #检索并列出已订购产品的清单#
检索并列出已订购产品的清单
https://www.nowcoder.com/practice/674d99a46a96494d8267ae4d162ed459
SELECT
OrderItems.order_num,
OrderItems.prod_id,
OrderItems.quantity
FROM
OrderItems
WHERE
prod_id IN ('BR01','BR02','BR03')
AND quantity>100
ORDER BY
order_num asc
查看10道真题和解析
