Suppliers(sid: integer, sname: string, address:string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real)The Catalog relation lists the prices charged for parts bySuppliers. Write the following queries in SQL:1) Find the sids of suppliers who supply a red part and a greenpart.2) Find the sids of suppliers who supply a red part or a greenpart.3) For every supplier that only supplies green parts, printthe name of the supplier and the total number of parts that shesupplies.4) For every supplier that supplies a green part and a redpart, print the name and price of the most expensive part that shesupplies