Using the table 1 below what queries would execute the following? MYSQL

File Edit Format View Help For each question, write the SQL query that would display the information asked by the question. Display information about parts that have their weights greater than the average weight of all parts. Find supplier mumbers who supply any screws (i.e., such that the part name is 'screw). The constraint is that you may not use any join or cross (product). (Hint Use subquery(ies)) Find suppher mumbers of suppliers located in London who supply screws ie, such that the part name is 'screw') or bolts. The constraint is that you may not use any join or product, but use a subquery(ies) Hint Use subquery(ies).) Display the total number of orders (over all parts) and the minimam, average, and maximum quantity of individual orders (each order is a tuple in sp). For each part find the total, minimum, average, and maximumquantity of indivihual orders (each order is a tuple in p) and the total number of orders. Display the part number and for that part the number of orders, total, minimum, average, maximum quantity of individual orders for that part and also the average quantity on order over all parts. Furthermore, display information in reverse order by part number. For each part find the total, minimum, average, and maximum quantity of individual orders (each order is a tuple in p) and the total number of orders, but only for those parts for which the average quantity on order is greater than the average quantity on order over all parts. Display the part number and for that part the mumber of orders, total, minimum, average, maximum quantity of individual orders for that part and also the average quantity on order over all parts. Furthermore, display information in reverse order by part nmumber Find each part for which its largest individual order in terms of quantity is larger than the largest quantity on order for either nut or a cam. and the largest quantity for a nut and the largest quantity for a cam 8. quantity and the average quantity on order for that part. Find each order for a part that is larger or equal to the average order for that part. Display, in an ascending order by part number, the part number, part name, Activate Windows Go to PC settings to activate Windows As above, but also display the part name. Name pColorpVeig SP gtv Figure 1. Supplier-Parts DB Tables