How can I write querys for the following?

A list of employee's registered for a job role. This should include the job role and employee’s first name and surname for each role. The employee’s names should be displayed in a single column.

A list of job roles showing the number of employees of each gender registered for each job role.

Alphabetical list of employee together with the name and phone number of their employer.
The list must have the first name and surname for each employee and the title, firstname, surname and phone number for their employer. The employer's title and name should be displayed in a single column. The listing should be sorted alphabetically by employee’s surname, first name.

how? by paying attention in SQL class

sorry, mate, we won't do your homework for you