SQL : can I get help with these sql questions please? I just need rotten answers not screen

Shots to prove

Part 2 (50 marks) Consider the following Supplier-Part database with three tables Suppler, Part, keys are underlined and foreign keys are obvious. Use both relational algebra ( (TRC) to express the following queries. Each query is 10 marks: Each result is 2 marks. and SP. e primary ALG) and tuple cale C is 4 marks and th The Prue cale ALG/TR Supplier SP NAME STATUS CITY S1 Smith 20 London S2 Jones 30 Paris S3 Blake 30 Paris S4 Clark 20 London S1 P1 300 S1 P2 200 SI P3 400 S1 P4 200 S1 P5 100 S1 P6 100 S5 Adams 130 Athens S2 P1 300 S2 P2 400 S3 P2 200 Part NAME COLOR WEIGHT CITY P1 Nut Red 12.0 London P2 Bolt Green 17.0 Paris P3 Screw Blue 17.0 Oslo P4 Screw Red14.0 London P5 Cam Blue 12.0 Paris P6 Cog Red 9.0 London S4 P2 200 S4 P3 300 S4 P4 400 S4 P5 500 S4 P6 600 1. Get the names of suppies who supply PL. 2. Get the names of suppliers who do not supply any part. 3. Get names of suppliers who supply all parts. Get the names of suppliers who supply all parts except Pl. 4. 5. Get the names of suppliers who supply more than two parts using aggregate operati