设有三个基本表，表ITEM(项目号，项目名，项目负责人，电话) ，BIP(项目号，零件号，数量，日期) ,PART(零件号，零件名称，规格，单价) ，完成SQL语统计出每个项目使用零件的金额和不同项目使用零件的合计金额，并将结果按表SSP(项目号，项目名，金额) 的结构显示。
SELECT ITEM.项目，项目名，SUM(单价*数量) AS 金额
FROM ITEM, BIP, PART
WHERE (12)
GROUP BY ITEM.项目
(13)
SELECT “合计”，SUM(单价*数量)
FROM BIP, PART
WHERE (14)
ORDER BY 1
(15)
参考答案：INSERT TABLE SSP
| 完形填空。 | |||
| A man was walking through a forest (森林). He had a few 1 in his hand. In the forest there were a lot of monkeys (猴子). It was hot, so he decided to 2 a rest under a tree. He put a capon his head and lay down to 3 . When he woke up, he couldn't find his caps." 4 are my caps?" he cried and looked up. He saw some monkeys in the tree. Each had a cap on its 5 "Give back my caps!" shouted the man to the 6 . But the monkey didn't understand him. They only jumped, danced and laughed. " 7 can I get back my caps?" he thought hard. At last he had an 8 . He took off his cap and threw it on the 9 . The little monkeys did, the baby is sleep the same thing. The man quickly picked up (拾起) all the caps 10 went on (继续) his way. | |||
| ( )1. A. caps (帽子) ( )2. A. sleep ( )3. A. shop ( )4. A. What ( )5. A. back ( )6. A. monkeys ( )7. A. Who ( )8. A. egg ( )9. A. tree ( )10. A. and | B. potatoes B. drink B. sleep B. Whose B. head B. people B. When B. orange B. ground B. but | C. toys C. practice C. tell C. Where C. hand C. others C. What C. idea C. table C. so | D. sunglasses D. have D. talk D. How D. arm D. madam D. How D. apple D. river D. or |