The following questions provide practice with SQL subqueries. For each, write a suitable SQL statement. (a) Using a subquery, display the staff details for the module leader of the module with the...

The following questions provide practice with SQL subqueries. For each, write a suitable SQL statement.

(a) Using a subquery, display the staff details for the module leader of the module with the code CCHO0418.

(b) Write two subqueries to display the staff details for all module leaders. One should be a correlated subquery, the other not.

(c) Using a subquery, display the module details for all modules except those led by staff who work in the computing department.