SQL Exercises--Individual


Download the database95 or database2000 to complete this assignment:

Write the SQL statement for the following.

  1. Get the name of all parts that have been shipped. (note - this is all parts that have been shipped, not just all parts.)

  2. Get the name of all suppliers that have shipped to Paris.

  3. Get all supplier numbers, part numbers, and project numbers where the indicated supplier, part, and project are located in the same city.

  4. Get part numbers for parts supplied by a supplier in London.

  5. Get part numbers for parts supplied by a supplier in London to a project based in London.

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