4) FIRED-UP: A Company which sell and repair stoves Assume that FiredUp has created a database with the following tables

[answerhappygod]

4 Fired Up A Company Which Sell And Repair Stoves Assume That Firedup Has Created A Database With The Following Tables 1 (40.69 KiB) Viewed 54 times

4) FIRED-UP: A Company which sell and repair stoves Assume that FiredUp has created a database with the following tables: CUSTOMER (CustomerSK. Name, Phone, EmailAddress) STOVE (SerialNumber, Type, Version, DateOfManufacture) REGISTRATION (CustomerSK. SerialNumber. Date) STOVE REPAIR (RepairInvoiceNumber. SerialNumber, Date, Description, Cost, CustomerSK) Code SQL for the following. Assume that all dates are in the format mmddyyyy. A. Show all of the data in each of the four FiredUp tables. B. List the Versions of all stoves, C. List the Versions of all stoves of the type 'Fired Now". D. List the SerialNumber and Date of all registrations in the year 2002. E. List the SerialNumber and Date of all registrations in February. Use the under- score () wildcard. F. List the SerialNumber and Date of all registrations in February. Use the percent (%) wildcard. G. List the names and email addresses of all customers who have an email address. H. List the names of all customers who do not have an EmailAddress: present the results in descending sorted order of Name. 1. Determine the maximum cost of a stove repair.