Assume that Fired Up has created a database with the following tables:
CUSTOMER (Customer, Name, Phone, Email Address)
STOVE (SerialNumber, Type, Version, Date Of Manufacture)
REGISTRATION (CustomerS, SerialNumber, Date)
STOVE_REPAIR (Repair Invoice Number, Serial Number, Date, Description, Total Cost, TotalPaid, CustomerSK)
A. Create a view called RepairSummary that shows only RepairInvoiceNumber, TotalCost, and TotalPaid.
B. Show a SQL statement to retrieve all RepairSummary data sorted by TotalCost.
C. Create a view called CustomerRepair that shows CUSTOMER.Name and STOVE_REPAIR.SerialNumber, Date, Description, and TotalDue, where TotalDue is the difference between TotalCost and TotalPaid.