Questions

Discuss among the team and come up with five distinct question classes relevant to the Yelp dataset.

Here is a simple question class provided as an example that has only one variable.

How many businesses in city X have more than Y stars?

Three example of specific questions in this class are:

• How many businesses in Boulder have more than 3 stars?
• How many businesses in Denver have more than 4 stars?
• How many businesses in Dallas have more than 2 stars?

How many businesses close after X time on a Y day?

• How many businesses close after 10 pm on Tuesday?
• How many businesses close after 5 pm on Monday?
• How many businesses close after 6 pm on Thursday?

How many businesses in X city are open between Y time and Z time?

Three example of specific questions in this class are:

• How many businesses in Boulder are open between 9am and 11am?
• How many businesses in Boulder are open between 12pm and 5pm?
• How many businesses in Boulder are open between 7pm and 1am?

How many business with X reviews have a rating of Y stars in Z state?

Three example of specific questions in this class are:

• How many businesses with greater than 300 reviews that have a rating of 4.5+ stars are located in New York?
• How many businesses with greater than 200 reviews that have a rating of >2 stars are located in Wyoming?
• How many businesses with less than 100 reviews that have a rating of 5 stars are located in Hawaii?

How many businesses have an X starting with 1 in Y? (address, state)

Three example of specific questions in this class are:

• How many businesses have an address starting with 1 in Wyoming?
• How many are there?
• How many don't start with 1?