18～25题所用的数据如表1和表2所示。表1 员工表(RG B.dbf)_爱下问搜题

搜题请搜索小程序“爱下问搜题”

问题单项选择题

18～25题所用的数据如表1和表2所示。

表1 员工表(RGB.dbf)

员工号	姓名	性别	籍贯	年龄	工资/元
0001	王吉兵	男	江苏	22	2003.50
0002	张晓春	女	安徽	21	2100.50
0003	左燕	女	江苏	23	2330.00
0004	赵华	男	安徽	22	2800.00
0005	李宁	男	山东	20	2600.00

表2 销售表(SSB.dbf)

员工号	商品号	金额/元
0001	0001	981
0002	0002	763
0001	0002	802
0002	0003	696
0003	0001	755
0003	0003	684
0004	0001	891
0005	0001	768
0004	0002	656
0003	0002	907
0001	0003	800

要统计出每一种商品的销售金额，下列语句正确的是______。

A．SELECT商品号，销售金额FROM SSB

B．SELECT商品号，SUM(金额)AS销售金额FROM SSB

C．SELECT商品号，SUM(金额)AS销售金额FROM SSB ORDER BY 1

D．SELECT商品号，SUM(金额)AS销售金额FROM SSB GROUP BY商品号

答案

参考答案：D

解析：

[分析]：要统计出每一种商品的销售金额，显然应按照商品号进行分组，并求出每一组的金额字段的和。

单项选择题

大连大豆期货市场某一合约的卖出价为2100元/吨，买入价为2103元/吨，前一成交价为2101元/吨，那么该合约的撮合成交价应为(　　)元/吨。

A．2100

B．2101

C．2102

D．2103

单项选择题

When I was looking for a Christmas present for my daughter in a toy store, a nicely dressed little girl, with some money in her little hand, was looking at some beautiful dolls. When she saw a doll she liked, she would ask her father if she had enough money. He usually said yes.
At the same time, a boy, with old and small clothes, was looking at some video games. He, too, had money in his hand, but it looked no more than five dollars. Each time he picked up one of the video games and looked at his father, he shook his head.
The little girl had chosen her doll, a very beautiful one. However, she noticed the boy and his father. She saw the boy give up a video game with disappointment and walk to another corner of the store.
The little girl put her doll back to the shelf and ran over to the video game. After she talked to her father, she paid for the video game and whispered(耳语) to the shop assistant.
So the boy got the video game that he wanted for free—he was told it was a prize from the store. He smiled happily, although he felt it was so incredible. The girl saw all this happen. She smiled, too.
When I walked out of the store to my car, I heard the father ask his daughter why she had done that. I would never forget their short talk. " Daddy, didn’t Grandma want me to buy something that would make me happy"
He said, "Of course, she did. "
"Well, I just did!" With that, the little girl started skipping towards their car happily.

What does the sentence "Well, I just did!" mean

A．I just did something for the boy and he would be happy.
B．I just bought a nice doll for myself and I would be happy.
C．I just bought a present for Grandma and she would be happy.
D．I just did something for the boy and it would make me happy.