Using SQL Scenario 1, which of the following SQL queries gives a list of departments and their employees?

A. SELECT depname,empname

FROMdepartments, employees

WHEREdepartments.depno = employees.empno

;

B. SELECT depname,empname

FROMdepartments, employees, workfor

WHEREdepartments.depno = workfor.depno

ANDworkfor.empno= employees.empno

;

C.SELECT depname,empname

FROMdepartments, workfor

WHEREdepartments.depno = workfor.depno

;

D.SELECT depno,empno

FROMworkfor

;

E.None of the above.