looking for some solutions? You are welcome.

SOLVED: SQL - get top 5 most liked and expensive products [on hold]

AGA:

I'm very new to SQL and trying to figure out how to get the top 5 list of most liked and expensive products sorted by retailer name for every city from this table:

Table Reviews:

ProductModelName,   
ProductCategory,    
ProductPrice,
RetailerName,   
RetailerZip,
RetailerCity,   
RetailerState,  
ProductOnSale,
ManufacturerName,
ManufacturerRebate,
UserID,
UserAge,
UserGender,
UserOccupation,
ReviewRating,
ReviewDate,
ReviewText



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent