Question No: $03$

This is a subjective question, hence you have to write your answer in the Text$-$Field given below.

Consider the following relations that have Suppliers information, Product information, and a Catalog that includes products from many suppliers: Supplier $($Sid$,$ Sname, Address$)$

Product $($Pid$,$ Pname, Color$)$

Catalog $($Sid$,$ Pid, Price$)$

Write the following queries in SQL

$[1+1+1+2$ marks $]$

a$.$ List names of products that have price of $100.$

b$.$ Find Sids of Suppliers who supply some red or green product.

c$.$ List names of Products along with minimum price at which they can be obtained from the Catalog

d$.$ List names of Suppliers who supply every Product with blue color.