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
Business Management: 1 show all of the data in each of the four tables 2 list
Reference No:- TGS02150911

Now Priced at $15 (50% Discount)

Recommended (99%)

Rated (4.3/5)