Problem
A. Write a query to show all the names of regions, names of countries and number of locations in them (including regions/countries with 0 locations). Sort by number of locations starting from the highest number.
B. Write a query to show all the employees who have salary between 9000 and 12000. Display: last name, first name, employee_id, department name, job title, salary. Sort the output by last name and first name.