Feel free to use Access QBE (query by example) if you nd it easier to do so, though what you have to show is the SQL: if you use QBE, you can go to the SQL view and nd the equivalent SQL query generated by Access. It may not be possible to implement some of the queries in QBE. Feel free to create views or to save queries (to help answer a more complex query) or to create other tables (eg: using the INTO command ) if that helps you. If you are using views or subqueries, show the SQL to create the views and subqueries, and show the tables for these views or subqueries.

below is all database tables

(e) What is the average cost of a part in the class "AP" (f) List the names of the parts which have been bought by at least two different customers (g) Find the names of the customers who have bought a Dryer but have not bought any other part. (h) Get a count of the number of warehouses which supply at least 4 parts. (i) From among the customers who placed at least 2 orders, find the name of the customer with the largest balance. (e) What is the average cost of a part in the class "AP" (f) List the names of the parts which have been bought by at least two different customers (g) Find the names of the customers who have bought a Dryer but have not bought any other part. (h) Get a count of the number of warehouses which supply at least 4 parts. (i) From among the customers who placed at least 2 orders, find the name of the customer with the largest balance