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