Plz helpme in my question

1)Display in alphabetical order the list of cities in which there is at least one customer
2)Display the number of customers who have placed at least one order.
3)Open a new SQL worksheet then write a SQL statement to create a view named’orderPerClient’ which will contain the number of orders placed by each customer. Save thisscript as view_creation.sql.