PLEASE WRITE SQL QUERIES FOR FOLLOWING QUESTIONS USING TABLE

SHIPMENT Sno Pno Oty Price ('sl, pl, 300, .005), ('s1', 'p2', 200, .009) ('s1', p3, 400, .004), ('s1', p4, 200, .009), ('s1', p5, 100, .01), (51', p6, 100, .01), ('s2', pl, 300, .006), ('s2', 'p2', 400, .004), ('s3', 'p2', 200, .009), (53, p3', 200, NULL), (s4', 'p2', 200, .008), ('s4', p3, NULL, NULL), (s4', p4', 300, .006), ('s4', p5", 400, .003) SUPPLIER no Sname Status Smith 20 s2 Jones 10 s3 Blake 30 Clark 20 Adams 30 City London Paris Paris London NULL PART Pno Pname Color Weight City pl Nut Red 12 London p2 Bolt Green 17 Paris p3 Screw NULL 17 Rome p4 Screw Red 14 London p5 Cam Blue 12 Paris p6 Cog Red 19 London