Which business has the best average review?

CSCI-4830-002-2014 / hackathon-yelp

0 stars 6 forks source link

Open LoganBates opened 10 years ago

LoganBates commented 10 years ago

If you want to make it harder, give the best average review for business not open on Sundays.

Irfann1 commented 10 years ago

So the query is:

db.business.find({ 'hours.Sunday' : { $exists:false} } , { '_id' : 0 , 'name' : 1, 'city' : 1, 'stars' : 1 }).sort({ 'stars' : -1 }).limit(50);

The top businesses not open on Sunday are:

Parsonage Bed & Breakfast in McFarland Lori's Pet-Agree Salon LLC in Middleton Killian Dental Clinic in Middleton

Here's the screenshot: notopen