EXERCISE SET 4
===============

The exercises are all based on the suppliers-parts-projects
database. You are supposed to write SQL queries that perform
the operations below:

1. Retrieve the supplier number, city, and the last name for
   all suppliers (table S). Sort by city then last name.

2. Get all part-color/part-city pairs currently represented in
   the database.

3. Retrieve the supplier number (S#), project number (J#) and
   quantity for all entries in the suppliers-parts-projects table
   that has less than 500 pieces of the part P3.

4. Return all city names from the table P. Make sure that the
   name of each city appears in the output exactly once. Sort the
   output in reverse alphabetical order.

5. Get all pairs of city names such that a supplier in the
   first city supplies a project in the second city.

6. Get project names for projects supplied by supplier S2.

7. Retrieve all numbers and names of all suppliers whose name
   contains an 'k' anywhere after the first position.

8. Write a compound query that retrieves all numbers and names
   of the suppliers and all number and names of the projects.

9. For each supplier, find out how many pieces of each part
   it supplies.

10.Get supplier number, part number, project number and
   quantity for suppliers that supply more pieces than the
   total number of the sixth part supplied by the fifth
   supplier.