问题 填空题

13.在教学管理数据库JxsJ中有2个表:XS.DBF(学生表)和CJ.DBF(成绩表),表结构如下: XS.DBF字段名 含义 字段类型及宽度 XH 学号 C(8) XM 姓名 C(8) XB 性别 C(2) CJ.DBF字段名 含义 字段类型及宽度 XH 学号 C(8) KCDH 课程代号 C(3) CJ 成绩 N(3)

(2)完善下列SELECT-SQL命令,其功能是基于XS表和CJ表查询有两门或两门以上课程不合格的学生情况。要求输出为XH、XM、选课门数和不及格门数,查询结果按不及格门数排序且将查询结果输出到打印机打印。(注:CJ小于60为不及格) SELECT XS.xh,XS.xm,COUNT(*) AS 选课门数, () AS 不及格门数; FROM jxsj!xs INNER JOIN jxsj!cj; ON Xs.xh=cj.xh; GROUP BY CJ.xh; ORDER BY 4 ( )

答案

参考答案:sum(iif(cj.cj

阅读理解

A friend of mine named Paul received an expensive car from his brother as a Christmas present. On Christmas Eve when Paul came out of his office, a street urchin(顽童) was walking around the shining car. “Is this your car, Paul?” he asked.

   Paul answered, “Yes, my brother gave it to me for Christmas.” The boy was surprised. “You mean your brother gave it to you and it didn’t cost you nothing ? Boy, I wish…”He hesitated.(犹豫)

  Of course Paul knew what he was going to wish for. He was going to wish he had a brother like that. But what the boy said surprised Paul greatly.

  “I wish,” the boy went on, “that I could be a brother like that.” Paul looked at the boy in surprise, then he said again, “Would you like to take a ride in my car?”

  “Oh yes, I’d love that.”

  After a short ride, the boy turned and with his eyes shining, said, “Paul, would you mind driving in front of my house?”

  Paul smiled a little. He thought he knew what the boy wanted. He wanted to show his neighbours that he could ride home in a big car. But Paul was wrong again. “Will you stop where those two steps are?” the boy asked.

  He ran up to the steps. Then in a short while Paul heard him coming back, but he was not coming fast. He was carrying his little crippled (残疾)brother. He sat him down on the step and

pointed to the car.

  “There she is, Buddy, just like I told you upstairs. His brother gave it to him for Christmas and it didn’t cost him a cent(美分). And some day I’m going to give you one just like it …then you can see for yourself all the nice things in the Christmas window that I’ve been trying to tell you about.”

  Paul got out and lifted the boy to the front seat of his car. The shining-eyed older brother climbed in beside him and the three of them began an unforgettable holiday ride.

根据短文内容,选择正确案。(10分)

小题1:The street urchin was very surprised when ________.

A. Paul received an expensive car    

B. Paul told him about the car

C. he saw the shining car

小题2: From the story we can see the urchin ______.

A. wished to give his brother a car

B. wanted Paul’s brother to give him a car

C. wished he could have a brother like Paul’s

小题3:The urchin asked Paul to stop his car in front of his house ____________

A. to show his neighbours the big car

B. to show he had a rich friend

C. to tell his brother about his wish

小题4:We can infer(推断) from the story that______.

A. Paul couldn’t understand the urchin

B. the urchin had a deep love for his brother

C. the urchin wished to have a rich brother

小题5:The best name of the story is ________

A. A Christmas Present    

B. A Street Urchin

C. A Brother Like That