Suppose a database has 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)
Write down the SQL code to complete the following requests.
1. Illustrate all data in each of the four tables. Don't show foreign key columns.
2. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.
3. Write all versions of stoves that are of type "Maytag" and they have not spent any money on repairs.