1.) Get J# values for projects using at least one part available from supplier S1.

2.) Get all pairs of CITY values such that a supplier in the first city supplied a project in the second city .

1115 : Table E SPJ: Table St +S Smith +S2 Jones S3 Blake SA Clark S5 Adams 10 Paris SI PI IJA 700 30 ParisS2 P3 400 Status City 20 London S2 P3 22 30 Athens S2 P3 3 20 ? P : Table S2 P3 J5 600 S2 P3 J6 400 12 London $2 P3 7 800 P#LEName l Color! Weight! City SPJ PName Color P2 Bolt Green P3 Screw Blue 17 Paris 17 Rome 3 P3 S2 P5 J2100 200 50b Ba P4 M2 + P4-Screw-Red |. 14London +P6 Cog E J: Table P5 CamBlue Red 19 London SAP67 300 City J JName City 155 P5?JZ 1100 1 Sorter Paris +112 Punch Rome P6-14 J3 Reader AthensS 31200 +J4 Console Athens J5 Collator London J6 Terminal Oslo 3 S5 PI IJA | 1001 City S5 P5?JA 1400