I need help with the SQL query for the following question:
1. Get top 5 list of products liked in Chicago
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:
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
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here