Question
SQL Queries
Download Stoves.accdb Access database in Doc Sharing; it has 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 down the SQL code to accomplish the following requests.
1. Show all data in each of the four tables.
2. List names and e-mail addresses of all customers who have had a stove fix that cost more than $50.
3. List all versions of stoves of type "Maytag" that have no record of being repaired.
You can view Microsoft tutorial, generate Queries for New Database, found in lecture to learn how to test your queries in Stoves.accdb. Don't worry about your SQL code being completely right. It's more significant for us to see different SQL code so we can evaluate and learn from the difference.