Create a query that lists the names, in alphabetic order, of all suppliers located in UK....

  

Transcribed Image Text:

Create a query that lists the names, in alphabetic order, of all suppliers located in UK. Create a query that displays the names of the suppliers that provide motors (see PARTYTYPE) costing between $50 and $115. 8. Create a query that finds the total cost of the parts used in each dishwasher manufactured after January 1, 2008. The result should only include those dishwashers that used at least $800 in parts. Create a procedure (PRC_INSPECTOR_AVG_SCORE) that lists appliances (appliance type) and average score a particular inspector has given. Parameter should be inspector name. With this we can see who has inspected which appliance and compare performances of inspectors (e.g., how generous or strict one inspector has been compared to others). Create an extra attribute (column) named 'TOTALSPENDING' (whose data type should be 6 digit numbers with 2 decimal places) and populate the column with the current total spending. Then, create a trigger (TRG_BUYER_UPDATE) that updates the column when there is a new purchase made in APPLIANCE table. APPLIANCE APPLIANCENUM APPLIANCETYPE DATEMANUF BUYERNUM PRICE INSPECTOR Appliance DB: Snapshot & Metadata BUYER INSPECTORNUM INSPECTORNAME SALARY DATEHIRE BUYERNUM BUYERNAME CITY COUNTRY CREDITRATING PART PARTNUM SUPPLIERNUM PARTTYPE COST APPLIANCENUM INSPECTION APPLIANCENUM INSPECTORNUM DATEINSPECTION SCORE SUPPLIER SUPPLIERNUM SUPPLIERNAME CITY COUNTRY PRESIDENT Create a query that lists the names, in alphabetic order, of all suppliers located in UK. Create a query that displays the names of the suppliers that provide motors (see PARTYTYPE) costing between $50 and $115. 8. Create a query that finds the total cost of the parts used in each dishwasher manufactured after January 1, 2008. The result should only include those dishwashers that used at least $800 in parts. Create a procedure (PRC_INSPECTOR_AVG_SCORE) that lists appliances (appliance type) and average score a particular inspector has given. Parameter should be inspector name. With this we can see who has inspected which appliance and compare performances of inspectors (e.g., how generous or strict one inspector has been compared to others). Create an extra attribute (column) named 'TOTALSPENDING' (whose data type should be 6 digit numbers with 2 decimal places) and populate the column with the current total spending. Then, create a trigger (TRG_BUYER_UPDATE) that updates the column when there is a new purchase made in APPLIANCE table. APPLIANCE APPLIANCENUM APPLIANCETYPE DATEMANUF BUYERNUM PRICE INSPECTOR Appliance DB: Snapshot & Metadata BUYER INSPECTORNUM INSPECTORNAME SALARY DATEHIRE BUYERNUM BUYERNAME CITY COUNTRY CREDITRATING PART PARTNUM SUPPLIERNUM PARTTYPE COST APPLIANCENUM INSPECTION APPLIANCENUM INSPECTORNUM DATEINSPECTION SCORE SUPPLIER SUPPLIERNUM SUPPLIERNAME CITY COUNTRY PRESIDENT