SQL语句： SELECT eeid, COUNT（*) FROM eeexam GROUP BY eeid HAVING COUNT（*)＞3 ORDER BY COUNT（*) DESC； 其查询的是（）。

A、WITH avgach (eeid,avgachieve) AS ( SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;

B、WITH avgach (eeid,avgachieve) ( SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;

C、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;

D、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80;

E、SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa) FROM department WHERE avgachieve>=80;

F、SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;

A、SELECT eid,ename FROM exampaper WHERE eid in (SELECT eid FROM eeexam GROUP BY eid HAVING COUNT(eeid)=(SELECT COUNT(eeid) FROM examinee) );

B、SELECT eid,ename FROM exampaper WHERE NOT EXIST (SELECT * FROM examinee WHERE NOT EXIST (SELECT * FROM eeexam WHERE examinee.eeid=eeid and exampaper.eid=eid) );

C、SELECT eid，ename FROM exampaper WHERE NOT EXISTS （（SELECT eeid FROM examinee） EXCEPT （SELECT eeid FROM eeexam WHERE exampaper.eid=eid））;

D、SELECT * FROM examinee ORDER BY eeid limit 2 offset ((SELECT count(*) FROM examinee)-2);

E、SELECT * FROM examinee ORDER BY eeid LIMIT (SELECT COUNT(*) FROM eeexam);

F、SELECT * FROM department WHERE EXISTS (SELECT * FROM examiner WHERE erdepa=department. dname AND eid= ername= '范冰冰');

G、SELECT eedepa, AVG(eeage) FROM examinee GROUP BY eedepa HAVING eedepa IN (SELECT eedepa FROM examinee WHERE eename='刘诗诗');

H、SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa) FROM department;

I、SELECT (SELECT eedepa FROM examinee WHERE eeexam.eeid=examinee.eeid), AVG(achieve) FROM eeexam GROUP BY (SELECT eedepa FROM examinee WHERE eeexam.eeid=examinee.eeid);

●设员工关系Emp(E_no，E_name，E_sex，D_name，E_age，E_Add)，关系Emp中的属性分别表示员工的员工号、姓名、性别、所在部门、年龄和通信地址；其中D_name是部门关系Dept的主键。查询各个部门员工的最大年龄、最小年龄，以及最大年龄与最小年龄之间年龄差的SQL语句如下：

SELECT D_name, MAX(E_age),MIN(E_age), (1)

FROM Emp

(2)，

(1) A． MAX(E_age)-MIN(E_age)IN 年龄差

B．年龄差IN MAX(E_age)-MIN(E_age)

C．MAX(E_age)-MIN(E_age)AS 年龄差

D．年龄差AS MAX(E_age)-MIN(E_age)

(2) A. GROUPBYE_name

B. GROUP BYD_name

C. ORDER BY E_name

D. ORDER BYD_name

设员工关系Emp（E_no，E_name，E_sex，D_name，E_age，E_Add），关系Emp中的属性分别表示员工的员工号、姓名、性别、所在部门、年龄和通信地址；其中D_name是部门关系Dept的主键。查询各个部门员工的最大年龄、最小年龄，以及最大年龄与最小年龄之间年龄差的SQL语句如下：

SELECT D_name, MAX（E_age）,MIN（E_age）, （61） FROM Emp （62），

（61）

A. MAX（E_age）-MIN（E_age）IN 年龄差

B. 年龄差IN MAX（E_age）-MIN（E_age）

C. MAX（E_age）-MIN（E_age）AS 年龄差

D. 年龄差AS MAX（E_age）-MIN（E_age）

（62）

A. GROUPBYE_name

B. GROUP BYD_name

C. ORDER BY E_name

D. ORDER BYD_name

Having rejected by everyone, the student representative resigned the committee.

A.Having rejected

B.everyone

C.representative

D.resigned

A．They work by motion.

B．They work by electricity.

C．They work by rubbing the food.

D．They work by sending short waves.

As we all know that young children are curious ________.

A.by heart

B.by origin

C.by education

D.by nature

【T18】

A.MINIMIZES LATENESS AND ABSENTEEISM

B.START TELECOMMUTING PROGRAMS TELECOMMUTING

C.REALITIES AND POPULAR IMAGES

D.TO THE QUIET ADIRONDACK MOUNTAINS A.ENCOURAGING COMPANIES TO【T13】______ IN ORDER TO REDUCE RUSH-HOUR TRAFFIC AND IMPROVE AIR QUALITY

B.A COMPUTER PROGRAMMER FROM NEW YORK CITY MOVES【T14】______

C.AN UNDERSTANDING OF THE DIFFERENCES BETWEEN【T15】______

D.TELECOMMUTING HELPS KEEP HIGH PERFORMERS ON BOARD,【T16】______BY ELIMINATING COMMUTERS, ALLOWS PERIODS OF SOLITUDE FOR HIGH-CONCENTRATION TASKS TELECOMMUTING—SUBSTITUTING THE COMPUTER FOR THE TRIP TO THE JOB—HAS BEEN HAILED AS A SOLUTION TO ALL KINDS OF PROBLEMS RELATED TO OFFICE WOR

K.FOR WORKERS IT PROMISES FREEDOM FROM THE OFFICE, LESS TIME WASTED IN TRAFFIC, AND HELP WITH CHILD-CARE CONFLICTS.FOR MANAGEMENT,【T17】______,AND PROVIDES SCHEDULING FLEXIBILITY.IN SOME AREAS, SUCH AS SOUTHERN CALIFORNIA AND SEATTLE, WASHINGTON, LOCAL GOVERNMENTS ARE【T18】______. BUT THESE BENEFITS DO NOT COME EASILY.MAKING A TELECOMMUTING PROGRAM WORK REQUIRESCAREFUL PLANNING AND【T19】______.MANY WORKERS ARE SEDUCED BY ROSY ILLUSIONS OF LIFE ASA TELECOMMUTER.【T20】______AND STAYS IN CONTACT WITH HER OFFICE VIA COMPUTER.A MANAGER COMES IN TO HIS OFFICE THREE DAYS A WEEK AND WORKS AT HOME THE OTHER TWO.AN ACCOUNTANT STAYS HOME TO CARE FOR HER SICK CHILD; SHE HOOKS UP HER TELEPHONE MODEM CONNECTIONS AND DOES OFFICE WORK BETWEEN CALLS TO THE DOCTOR.

【T14】

A.MINIMIZES LATENESS AND ABSENTEEISM

B.START TELECOMMUTING PROGRAMS TELECOMMUTING

C.REALITIES AND POPULAR IMAGES

D.TO THE QUIET ADIRONDACK MOUNTAINS A.ENCOURAGING COMPANIES TO【T13】______ IN ORDER TO REDUCE RUSH-HOUR TRAFFIC AND IMPROVE AIR QUALITY

B.A COMPUTER PROGRAMMER FROM NEW YORK CITY MOVES【T14】______

C.AN UNDERSTANDING OF THE DIFFERENCES BETWEEN【T15】______

D.TELECOMMUTING HELPS KEEP HIGH PERFORMERS ON BOARD,【T16】______BY ELIMINATING COMMUTERS, ALLOWS PERIODS OF SOLITUDE FOR HIGH-CONCENTRATION TASKS TELECOMMUTING—SUBSTITUTING THE COMPUTER FOR THE TRIP TO THE JOB—HAS BEEN HAILED AS A SOLUTION TO ALL KINDS OF PROBLEMS RELATED TO OFFICE WOR

K.FOR WORKERS IT PROMISES FREEDOM FROM THE OFFICE, LESS TIME WASTED IN TRAFFIC, AND HELP WITH CHILD-CARE CONFLICTS.FOR MANAGEMENT,【T17】______,AND PROVIDES SCHEDULING FLEXIBILITY.IN SOME AREAS, SUCH AS SOUTHERN CALIFORNIA AND SEATTLE, WASHINGTON, LOCAL GOVERNMENTS ARE【T18】______. BUT THESE BENEFITS DO NOT COME EASILY.MAKING A TELECOMMUTING PROGRAM WORK REQUIRESCAREFUL PLANNING AND【T19】______.MANY WORKERS ARE SEDUCED BY ROSY ILLUSIONS OF LIFE ASA TELECOMMUTER.【T20】______AND STAYS IN CONTACT WITH HER OFFICE VIA COMPUTER.A MANAGER COMES IN TO HIS OFFICE THREE DAYS A WEEK AND WORKS AT HOME THE OTHER TWO.AN ACCOUNTANT STAYS HOME TO CARE FOR HER SICK CHILD; SHE HOOKS UP HER TELEPHONE MODEM CONNECTIONS AND DOES OFFICE WORK BETWEEN CALLS TO THE DOCTOR.

【T20】

A.MINIMIZES LATENESS AND ABSENTEEISM

B.START TELECOMMUTING PROGRAMS TELECOMMUTING

C.REALITIES AND POPULAR IMAGES

D.TO THE QUIET ADIRONDACK MOUNTAINS A.ENCOURAGING COMPANIES TO【T13】______ IN ORDER TO REDUCE RUSH-HOUR TRAFFIC AND IMPROVE AIR QUALITY

B.A COMPUTER PROGRAMMER FROM NEW YORK CITY MOVES【T14】______

C.AN UNDERSTANDING OF THE DIFFERENCES BETWEEN【T15】______

D.TELECOMMUTING HELPS KEEP HIGH PERFORMERS ON BOARD,【T16】______BY ELIMINATING COMMUTERS, ALLOWS PERIODS OF SOLITUDE FOR HIGH-CONCENTRATION TASKS TELECOMMUTING—SUBSTITUTING THE COMPUTER FOR THE TRIP TO THE JOB—HAS BEEN HAILED AS A SOLUTION TO ALL KINDS OF PROBLEMS RELATED TO OFFICE WOR

K.FOR WORKERS IT PROMISES FREEDOM FROM THE OFFICE, LESS TIME WASTED IN TRAFFIC, AND HELP WITH CHILD-CARE CONFLICTS.FOR MANAGEMENT,【T17】______,AND PROVIDES SCHEDULING FLEXIBILITY.IN SOME AREAS, SUCH AS SOUTHERN CALIFORNIA AND SEATTLE, WASHINGTON, LOCAL GOVERNMENTS ARE【T18】______. BUT THESE BENEFITS DO NOT COME EASILY.MAKING A TELECOMMUTING PROGRAM WORK REQUIRESCAREFUL PLANNING AND【T19】______.MANY WORKERS ARE SEDUCED BY ROSY ILLUSIONS OF LIFE ASA TELECOMMUTER.【T20】______AND STAYS IN CONTACT WITH HER OFFICE VIA COMPUTER.A MANAGER COMES IN TO HIS OFFICE THREE DAYS A WEEK AND WORKS AT HOME THE OTHER TWO.AN ACCOUNTANT STAYS HOME TO CARE FOR HER SICK CHILD; SHE HOOKS UP HER TELEPHONE MODEM CONNECTIONS AND DOES OFFICE WORK BETWEEN CALLS TO THE DOCTOR.