1.)Get S# values for suppliers who supply both projects J1 and J2.

2.)Get S# values for suppliers who supply project J1 with a red part.

3.) Get P# values for parts supplied to any project in London.

4.)Get P# values for parts supplied to any project by a supplier in the same city.

5.)Get J# values for projects supplied by at least one part available from supplier S1.

SPJ: Table 11 S : Table S# ! SName | Status | City S1 Smith S2 Jones S3 Blake S4 Clak S5 Adams 20 London LE1.PI JI 10 ParisS1 P1 J4 700 30 Paris Status 20 London S2 P3 2 20 P: Table | | P#| PName | Color | Weight | City S2 P3 J6 400 SPJ er +P1 Nut Red | 1-1 + P2-Bolt . Green 17 ParisS2 P5 2 100 P3 Screw Blue P4 Screw Red +P5 Cam Blue 4 LondonS3 PA J2500 2 Paris Color +P6 Cog Red 19 London City S5P2?JA 100 S5 P5135 | S5 P5 100 ? J : Table J#?JName! City Sorter Paris 2 Punch Rome Jf JName City J3 Reader Athens IJA ?Console-Athens- E95 |PATJA 5 Collator London tJ6 Terminal Oslo 195P5?JA 1400 P6