( )句可以实现显示 id 和 description ,条件满足订单时间在 January 1, 1997 以前的,且单价小于 1.00 或者大于 5.00 的, 结果用订单时间降序排列
SELECT id_number, description FROM inventory
WHERE price IN (1.00, 5.00) OR order_date < '01-JAN-97'
ORDER BY order_date DESC;
SELECT id_number, description FROM inventory
WHERE price BETWEEN 1.00 AND 5.00 OR order_date < '01-JAN-1997'
ORDER BY order_date;
SELECT id_number, description FROM inventory
WHERE price < 1.00 OR price > 5.00 AND order_date < '01-Jan-97'
ORDER BY order_date ASC;
SELECT id_number, description FROM inventory
WHERE (price <1.00 OR price > 5.00) AND order_date < '01-JAN-1997'
ORDER BY order_date DESC;