Question: THE TABLE IS NOT THE ANSWER TO THE QUESTION! PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS BASED ON WHAT YOU SEE FROM THE
THE TABLE IS NOT THE ANSWER TO THE QUESTION! PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS BASED ON WHAT YOU SEE FROM THE TABLE.
1. Table: yelp_business
a) Find the review count for one-star businesses from yelp. Output the name along with the corresponding review count.
b) Find the top 5 states with the most 5 star businesses. Output the state name along with the number of 5-star businesses and order records by the number of 5-star businesses in descending order. In case there are two states with the same result, sort them in alphabetical order.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
