PLEASE ONLY DO 4,5,7,8

Use Query By Example (QBE) to express queries 1,2,4,5,7,8 SP Suppliers SHSNAME STATUS CITY SH P# QTY. S P 300 S P2 200 SP3 400 S P4 200 SIP5 100 S P6 100 S2 P 300 S2 P2 400 S3 P 300 S3P2 200 S4P2 200 S4 P3 300 S4P4 400 S4P 500 S4P6 600 S1 Smith20 London S2 Jones 30 Paris S2 Jones S3Blake S4Clark S5 Adams 30 20 London 30 Athens Paris Parts PA PNAME COLOR WEIGHT CITY S2P2 P Nut P2 BoltGreen P3 Screw P4 Screw Red P5 Cam Red 12.0London 17.0 17.0 Paris Blue Oslo 0London Blue 12.0 Paris Red 19.0 London