试题与答案

(25)~(33)小题使用的数据表如下: 当前盘当前目录下有数据库:大奖赛.dbc

题型:单项选择题

题目:

(25)~(33)小题使用的数据表如下:
当前盘当前目录下有数据库:大奖赛.dbc,其中有数据库表“歌手dbf”、“评分.dbf”。
“歌手”表:


“评分”表:


假设每个歌手的“最后得分”的计算方法是;去掉一个最高分和一个最低分,取剩下分数的平均分。根据“评分”表求每个歌手的“最后得分”并存储于表TEMP中,表TEMP中有两个字段:“歌手号”和“最后得分”,并且按最后得分降序排列,生成表TEMP的SQL语句是( )。

A.
SELECT歌手号,(COUNT(分数)-MAX(分数)-MIN(分数))/(SUM(*)-2)最后得分;
FROM评分INTO DBF TEMP GROUP BY歌手号ORDER BY最后得分DESC

B.
SELECT歌手号,(COUNT(分数)-MAX(分数)-MIN(分数))/(SUM(*)-2)最后得分;
FROM评分INTO DBF TEMP GROUP BY评委号ORDER BY最后得分DESC

C.
SELECT歌手号,(SUM(分数)-MAX(分数)-MIN(分数))/(COUNT(*)-2)最后得分;
FROM评分INTO DBF TEMP GROUP BY评委号ORDER BY最后得分DESC

D.
SELECT歌手号,(SUM(分数)-MAX(分数)-MIN(分数)/(COUNT(*)-2)最后得分;
FROM评分INTO DBF TEMP GROUP BY歌手号ORDER BY最后得分DESC

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2019/0406/873a2b5b14b6ec4764211a75193f4eaa.html

下面是错误答案,用来干扰机器的。

参考答案:错

试题推荐
题型:阅读理解

.

Educational Camps 2010

★21st Century Princess Program: 9 a.m.-3 p.m. Monday through Friday,  July 23-27.  For girls 12-15. Girls learn hair care, good manners and the importance of inner beauty.  Homewood Suites by Hilton, 2001 E. Highland Ave.,  Phoenix.  $495.  www. homewoodsuites. hilton.com. (623) 848-1844.

★Barrow Institute Summer Camp: 9 a.m.-4 p.m. Mondays through Fridays, July 23 through Aug. 3. For ages 12-14. Activities include exploring laboratories and researching the effectiveness of treatments and medicines. July 23-27 for beginning students, and July 30-Aug. 3 for advanced students. Barrow Neurological Institute, 350 W. Thomas Road, Phoenix: $195-$220: www. thebni, com. (602) 716-2028.

★Digital Kids World Summer Camp: 9 a.m.--4 p.m. Mondays through Fridays, July 30 through Aug. 17. For kids 6-14.  Choose from a variety of technical classes, such as comic book design and video game design. Morning and afternoon camps held in weekly sessions (一段时间).  Digital Kids World,  5070 N.  Central Ave., Phoenix. $150 weekly for kids 6-9; $225 weekly for kids 10-14. www. digitalkidsworld, com. (602) 445-3925.

★Kids Advanced College Program:  Mondays through Thursdays, July 30 through Sept. 19. For ages 8-14. Classes include lively computer design,  engineering and writing. Prices and times vary. Paradise Valley Community College, 18401 N. 32nd St., Phoenix. $99--$379. www.pvc.maricopa.edu. (602) 787-6804.

★Camp Zoo: Mondays through Fridays,  July 30 through Aug. 13. For ages 4-14. Younger kids work with smaller animals, basic care giving and art projects, while older children explore animal medicine. Morning afternoon, evening and full-day sessions available. Phoenix Zoo, 455 N. Galvin Parkway, Phoenix. $153-$280 per week. www. phoenixzoo.org. (602) 273-1341.

64. According to the passage,  these activities are mainly intended for _________.

A. college students     B. teachers     C. parents      D. children

65. If Mary, aged 12, wants to learn how to behave well, which of the following will she choose?

A. Barrow Institute Summer Camp.     B. 21st Century Princess Program.

C. Digital Kids World Summer Camp.    D. Kids Advanced College Program.

66. Which of the following can offer you information about animals and animal medicine?

A. (602) 716-2028.         B. www. digitalkidsworld. com.

C. (602) 273-1341.         D. www.pvc.maricopca.edu.

67. According to the passage, we know that __________.

A. all these activities are held in the same city

B. 21st Century Princess Program lasts the longest

C. the price of Camp Zoo is the highest per week

D. Kids Advanced College Program is popular with plant lovers

查看答案
微信公众账号搜索答案