Question: The following tables provide a very small portion of the
The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in problem65.
Answer to relevant QuestionsWrite a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental (result shown in FigureP7.92).Write a query to display the membership number, last name, and total rental fees earned from that membership (result shown in Figure.). The total rental fee is the sum of all of the detail fees (without the late fees) from ...Write the SQL code that will produce a virtual table named REP_1. The virtual table should contain the same information that was shown in Problem.Use a query to compute the average purchase amount per product made by each customer.Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made a sale to a customer ...
Post your question