This exercise includes a table of various data gathered on Yelp. Try to answer the following questions with the appropriate SQL query and create graphs using the graphics function in Strata Scratch.
The datasets.yelp_business table contains various data gathered on Yelp such as users, reviews, ratings, business address and categories.
What are the top 5 states with the most 5 star businesses?
What are the top 5 cities with the most 5 star businesses? Limit visualization to 10.
What are the top 5 businesses with the most reviews?
What are the top category businesses most people review for?
What are the most one star review businesses from yelp?
How many businesses are open?
What is the average stars of each states?
The datasets.yelp_checkin table provides the amount of check-ins each business has and when that check-in took place. Check-ins are offered with rewards that businesses give to customers whenever they “check-in” to the business on Yelp. By using the check-in feature, customers are able to broadcast to their friends on Yelp that they’re at your business.
What are the top 5 businesses with the most check-ins?