Show all the data in each of the four tables


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. 

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Show all the data in each of the four tables
Reference No:- TGS099901

Expected delivery within 24 Hours