shop'#错误，无法运行

Question

shop=# SELECT product_name, product_type,
shop-#        sale_price * 0.9 - purchase_price AS profit
shop-#   FROM Product
shop-#  WHERE sale_price * 0.9 - purchase_price > 100
shop-#    AND (   product_type = '办公用品'
shop(#         OR product_type = '厨房用具');

可运行出

 product_name | product_type | profit
--------------+--------------+--------
 打孔器       | 办公用品     |  130.0
 高压锅       | 厨房用具     | 1120.0
(2 行记录)

再次输入不可运行

```sql
shop'# SELECT product_name, product_type,
shop'#        sale_price * 0.9 - purchase_price AS profit
shop'#   FROM Product
shop'#  WHERE sale_price * 0.9 - purchase_price > 100
shop'#    AND (   product_type = '办公用品'
shop'#         OR product_type = '厨房用具');
shop'#         OR product_type = '厨房用具');

Answer 1

SELECT product_name, product_type,
       sale_price * 0.9 - purchase_price AS profit
FROM Product
WHERE sale_price * 0.9 - purchase_price > 100
AND (product_type = '办公用品' OR product_type = '厨房用具');