Archived: Chapter 2: Twenty Second Annual Report to ...

FROM DOCTOR , SALARY. WHERE SEX = ‘M’ AND DOCTOR.ID = SALARY.ID; (1/2 mark for correct Select statement) (1/2 mark for correct Where clause) (v) SELECT count(*) from DOCTOR where SEX = “F” (v) 4 (1 mark for correct answer) (vi) SELECT NAME, DEPT, BASIC from DOCTOR, SALARY. where DEPT = “ENT” and DOCTOR.ID = SALARY.ID (vi) NAME DEPT ... ................
................