Stuck on Oracle logic

Stuck on bonus question I have.

It asks:

Display department name, city and number of different jobs in each department. - If city is null, you should print Not Assigned Yet. - This column should have alias City. Column that shows # of different jobs in a department should have the heading # of Jobs Limit the width of the City to 25 characters.

The 'department_name' is located in the 'departments' tables. 'city' is located in 'locations' 'job_id' is lcoated in 'employees'

Any help is appreciated. Thank you.