SQL92 商品交易(网易校招笔试真题)
描述
如下有一张商品表(goods),字段依次为:商品id、商品名、商品质量
+------+------+--------+
| id | name | weight |
+------+------+--------+
| 1 | A1 | 100 |
| 2 | A2 | 20 |
| 3 | B3 | 29 |
| 4 | T1 | 60 |
| 5 | G2 | 33 |
| 6 | C0 | 55 |
+------+------+--------+
还有一张交易表(trans),字段依次为:交易id、商品id、这个商品购买个数
+------+----------+-------+
| id | goods_id | count |
+------+----------+-------+
| 1 | 3 | 10 |
| 2 | 1 | 44 |
| <