SQL Queries
Download the Stoves.accdb Access database in Doc Sharing; it has the following tables filled with data.
CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateofManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)
Given these tables, write the SQL code to accomplish the following requests.
1. Show all the data in each of the four tables.
2. List the names and e-mail addresses of all customers who have had a stove repair that cost more than $50.
3. List all versions of stoves of type "Maytag" that have no record of being repaired.
You can view the Microsoft tutorial, Create Queries for a New Database, found in the lecture to learn how to test your queries in Stoves.accdb. Don't worry about your SQL code being completely correct. It's more important for us to see different SQL code so we can evaluate and learn from the differences.