1. Find distinct countries of all the customers and suppliers in alphabetical order 2. Find the list of countries of suppliers and customers with a record for each one. 3. Find distinct cities that we have a supplier and customer located in
1.
Find distinct countries of all the customers and suppliers in alphabetical order
2.
Find the list of countries of suppliers and customers with a record for each one.
3.
Find distinct cities that we have a supplier and customer located in
4.
Find the count of the number of customers and suppliers pairs that are in the same city.
5.
Find the cities we have a supplier with no customers.
6.
How many customers do we have in cities without suppliers
7.
Find all the suppliers with a product that costs more than $200
8.
Find all the suppliers that don’t have an order in December, 1996
9.
Find all the suppliers that have had an order with 1 item
10.
Find all distinct customers that ordered more in one item than the average order amount
per item of all the customers. In other words, Sind all distinct customers that have an order
that’s greater than the average order of all the customers put together.
11.
Find all the suppliers that are in the same city as a customer.
Step by step
Solved in 3 steps
