有语句： SELECT DISTINCT erid FROM erexam WHERE erid IN （SELECT erid FROM examiner WHERE e

A、

B、

C、

D、

E、

F、

G、

H、

I、

J、

K、

A、

B、

C、

D、

E、

F、

G、

H、

I、

J、

K、

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);

A、考官的总人数

B、每一部门的考官人数

C、考官服务的院系数

D、每一考官服务的院系数

A、

B、

C、

D、

E、

F、

G、

A、

B、

C、

D、

E、

F、

G、

关系代数表达式：其对应的SQL语句为（ ）。

A、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 AND eeage<=23;<br> B、SELECT * FROM examinee WHERE eeage>=18 AND eeage<=23;<br> C、SELECT eename,eeage,eesex FROM examiner WHERE eeage>=18 AND eeage<=23;<br> D、SELECT eename,eeage,eesex FROM examinee WHERE 18<=eeage<=23;<br> E、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 HAVING eeage<=23;<br> F、SELECT eename,eeage,eesex FROM examinee HAVING eeage>=18 AND eeage<=23;<br> G、SELECT eename,eeage,eesex FROM examinee HAVING eeage>=18 OR eeage<=23;<br> H、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 OR eeage<=23;<br>

关系代数表达式：其对应的SQL语句为（ ）。

A、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 AND eeage<=23;<br> B、SELECT * FROM examinee WHERE eeage>=18 AND eeage<=23;<br> C、SELECT eename,eeage,eesex FROM examiner WHERE eeage>=18 AND eeage<=23;<br> D、SELECT eename,eeage,eesex FROM examinee WHERE 18<=eeage<=23;<br> E、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 HAVING eeage<=23;<br> F、SELECT eename,eeage,eesex FROM examinee HAVING eeage>=18 AND eeage<=23;<br> G、SELECT eename,eeage,eesex FROM examinee HAVING eeage>=18 OR eeage<=23;<br> H、SELECT eename,eeage,eesex FROM examinee WHERE eeage>=18 OR eeage<=23;<br>