Computer Science 455

Third Exercise Set

Due: Tuesday, Feb. 23.

Write SQL statements for the following queries:

1. Find full details of all projects in London.
2. Get supplier number values for suppliers who supply project J1
3. Get JNAME values for projects supplied by supplier S1
4. Get supplier number values for suppliers who supply project J1 with a red part
5. Get supplier name values for suppliers who supply a London project with a red part

Place these in a file called SQL01.SQL in your root directory on the VAX. The file should have the following format:

echo on
/*
     Your name here
*/
/*
     Problem 1:  Find full details of all
     projects in London
*/
select ....
/*
     Problem 2: .....
 
*/
 
EXIT
 

Any questions? Please let me know. Many thanks!