a. List the names, in alphabetic order, of the suppliers located in London, Liverpool, and Manchester, UK.
b. List the names of the suppliers that supply motors (see PARTTYPE) costing between $50 and $100.
c. Find the average cost of the motors (see PARTTYPE) supplied by supplier number 3728.
d. List the names of the inspectors who were inspecting refrigerators (see APPLIANCE - TYPE) on April 17, 2011.
e. What was the highest inspection score achieved by a refrigerator on November 3, 2011?
f. Find the total amount of money spent on Quality Appliance products by each buyer from Mexico, Venezuela, and Argentina.
g. Find the total cost of the parts used in each dishwasher manufactured on February 28, 2010. Only include in the results those dishwashers that used at least $200 in parts.
h. List the highest paid inspectors.
i. List the highest paid inspectors who were hired in 2009.
j. Among all of the inspectors, list those who earn more than the highest
-paid inspector who was hired in 2009
b. List the names of the suppliers that supply motors (see PARTTYPE) costing between $50 and $100.
c. Find the average cost of the motors (see PARTTYPE) supplied by supplier number 3728.
d. List the names of the inspectors who were inspecting refrigerators (see APPLIANCE - TYPE) on April 17, 2011.
e. What was the highest inspection score achieved by a refrigerator on November 3, 2011?
f. Find the total amount of money spent on Quality Appliance products by each buyer from Mexico, Venezuela, and Argentina.
g. Find the total cost of the parts used in each dishwasher manufactured on February 28, 2010. Only include in the results those dishwashers that used at least $200 in parts.
h. List the highest paid inspectors.
i. List the highest paid inspectors who were hired in 2009.
j. Among all of the inspectors, list those who earn more than the highest
-paid inspector who was hired in 2009
