1 show all of the data in each of the four tables 2 list


The following tables filled with data have already been created:

CUSTOMER (CustomerSK, Name, Phone, EmailAddress)

STOVE (SerialNumber, Type, Version, DateofManufacture)

REGISTRATION (CustomerSK, SerialNumber, Date)

STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)

Given the tables, write the SQL code to accomplish the following requests.

1. Show all of 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 costs more than $50.

3. List all versions of stove of type "Maytag" that have no record of being repaired.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: 1 show all of the data in each of the four tables 2 list
Reference No:- TGS02149460

Now Priced at $15 (50% Discount)

Recommended (98%)

Rated (4.3/5)