SQL

Hi, Can anyone help in code/p-code for following:

1-Count the number of employees who have been on any course.

2-List all employees by surname and forenames who have been on a course in 1988.

3-List in order of forename within surname within department name, the current position of all employees.

4-List the number of employees who have been on each course.

Any fieldname, table name you can use