Download the database95
or database2000 to complete this assignment:
Write the SQL statement for the following.
- Get the name of all parts that have been shipped. (note - this is all parts that have
been shipped, not just all parts.)
- Get the name of all suppliers that have shipped to Paris.
- Get all supplier numbers, part numbers, and project numbers where the indicated
supplier, part, and project are located in the same city.
- Get part numbers for parts supplied by a supplier in London.
- Get part numbers for parts supplied by a supplier in London to a project based in
- Get project names for projects supplied by supplier S1.