1. 1. Create a query that will allow the user to search the minimum tank size field and the type of fish in the fish table. The search for any minimum tank size and type of fish should be possible. This is a keyword search query. The query should ask the question “please enter minimum tank size and enter the type of fish you are looking for”. Display the product ID, product name, and list price in the result.
2. Manager Queries:
3. 2. We know that certain credit card companies charge the merchant a higher fee than others for processing. Assume that Discover card charges .5% fee, Visa a 1% fee, Mastercard a 1.5% fee, and American Express a 2% fee. You can see these transaction fees have been entered for you in a database table. Calculate the amount of credit card fees paid—in total and to each credit card company. 
4. 3. Of all customers who placed a sale, which credit rating is used the most? Measure most by dollar amount. Show all available credit ratings in your answer.  
5. Auditor Queries—Ending Inventor
6. 4. What is the ending quantity of each food item after all walk-in sales have been completed? Show all 30 food Product IDs in your answer.  
7. Auditor Queries—Complex Query:
8. 
   
9. 5. List all tanks that are not sold by walkin sales, and therefore may need to be written off as obsolete inventory, nonsaleable. Calculate the cost of each tank that is not sold, ie. quantity not sold x cost. Include an overall total in datasheet view. 
10. Bonus Query:
11. 6. What is the percentage of total credit card fees to total walkin sales?