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 = '厨房用具');
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 = '厨房用具');
在再次输入不可运行截图的倒数第一行，第二行有两个分号，分号代表sql语句的结尾
第9行是重复的，多粘了