SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART

Please Help me out in these queries.

1. Get the supplier number(s) who supply Red parts. 

2. Get supplier names who supplies less than two parts. 

3. Get all pairs of supplier numbers who reside in the same city.

s (Supplier) SNAME Smith S2 Jones S3 Blake S4 Clark S5 Adams P Part PNAME PI Nut Bolt P2 P3 Screw P4 Screw P5 Cam P6 Cog SP 300 P2 200 400 P4, 200 PS 100 100 S2 Pu 300 P2 400 P2 200 P2 200 S4 P4 300 400 STATUS 20 30 20 30 COLOR Red Green Blue Red Blue Red CITY London Paris Paris London Athens WEIGHT CITY 12.0 17.00 17.0 14.0 12.0 19.00 London Paris Rome London Paris London