I need help with the SQL query for the following question: 1. Get show the total number of customers who complained about heat issues for every product name of every manufacturer. Here is the...


I need help with the SQL query for the following question:



1. Get show the total number of customers who complained about heat issues for every product name of every manufacturer.


Here is the information on the field names:



The table name is:  Reviews



Review Form Fields


Product/ModelName:


Product/Category:


Product/Price:


Retailer/Name:


Retailer/ZipCode:


Retailer/City:


Retailer/State:


Product/On Sale:


Manufacturer/Name:


Manufacturer/Rebate:


Review/UserId:


Review/Rating:


Review/Date:


Review/Text:


Example of Review Form Filled out


ProductModelName: Galaxy S4


ProductCategory: Smart Phone


ProductPrice: 499


RetailerName: Bestbuy


RetailerZipCode: 44114


RetailerCity: Cleveland


RetailerState: OH


ProductOnSale: No


ManufacturerName: Samsung


ManufacturerRebate: No


ReviewUserId: xmm473


ReviewRating: 3


ReviewDate: 6/10/2012


ReviewText: overheats after 2 hours



Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here