Consider the following schema. Write the following five queries based

on your choice in QBE:

Suppliers$($sid: integer, sname: string, city: string$)$

Parts$($pid: integer, pname: string, color: string$)$

Orders$($sid: integer, pid: integer, quantity: integer$)$

$1.$ For each supplier from whom all of the following things have been ordered in quantities of at

least $150,$ print the name and city of the supplier: a blue gear, a red crankshaft, and a yellow

bumper.

$2.$ Print the names of the purple part$3.$ Print the names and cities of suppliers who have an order for more than $150$ units of a yellow

or purple part.

$4.$ Print the pids of parts that have been ordered from a supplier named American but have also

been ordered from some supplier with a different name in a quantity that is greater than the

American order by at least $100$ units.

$5.$ Print the names of the suppliers located in Madison. Could there be any duplicates in the

answer?

$6.$ Print all available information about suppliers that supply green parts.

$7.$ For each order of a red part, print the quantity and the name of the part.

$8.$ Print the names of the parts that come in both blue and green. $($Assume that no two distinct

parts can have the same name and color.$)$

$9.$ Print $($in ascending order alphabetically$)$ the names of parts supplied both by a Madison

supplier and by a Berkeley supplier.

$10.$ Print the names of parts supplied by a Madison supplier, but not supplied by any Berkeley

supplier. Could there be any duplicates in the answer?

$11.$ Print the total number of orders.

$12.$ Print the largest quantity per order for each sid such that the minimum quantity per order for

that supplier is greater than $100.$

$13.$ Print the average quantity per order of red parts.

$14.$ Can you write this query in QBE? If so$,$ how? Print the sids of suppliers from whom every

part has been ordered