SQL COMMANDS

1. Display the region description and the number of territories in each region.

2. Display the region description and the number of employees in each region.

3. Display the company names and the number of products they are supplying.

4. Display the number of suppliers from each country.

5. Display the company names and phone numbers of suppliers with no fax number.

6. Display the number of orders for each customer/company.

7. Display the number of orders for each product.

8. Find out how many orders were shipped via Federal Shipping.

9. Find out how many orders were shipped by each shipper.

10. Find out the order_id of the order with the maximum freight and its ship_name.