Write a query to break down the groups by ratings, showing the count of groups with no ratings, as well as a count of each of the following ranges: 1-1.99, 2-2.99, 3-3.99, 4-4.99, and 5.

Note: If a group has no ratings, its rating will appear as "0" in the ratings column of the grp table. hint Use a CASE WHEN or IF/THEN statement to categorize the ratings.

Guiding Questions To Consider

• How many groups have 5 star ratings?
• Of the groups that have been rated, what percent of groups are rated 5 stars?
• Is this a reliable measure of the success or popularity of the group?

b. Instead of focusing on rating alone, you should also look at membership numbers. Of the groups who have perfect 5 star ratings, write a query to find those with the most members.

c. Adjust your previous query to include the city for each group to ensure you are selecting three groups from New York, one from Chicago and one from San Francisco. Hint You'll need to JOIN the city table to access the city names.

d.

Before making your selection, you need to ensure you are choosing from a wide variety of groups. Make sure your query includes the category information before making your recommendations.

Guiding Questions and Considerations:

• Should you only include groups from the most popular categories?
• What about including only groups from the least represented categories to try and increase the variety of groups on LetsMeet?

gip_member member_id INT(11) 2 cty VARCHAR(45) country CHAR(2) hometown VARCHAR(45) joined DATETIME member_name VARCHAR(45) member_status ENUM(...) visited DATETIME group_id INT(11) Indexes category category_id INT(11) category_name VARCHAR(45) shortname VARCHAR(45) sort_name VARCHAR(45) Indexes # 4 venue_ venue_id INT(11) event address_1 VARCHAR(200) event_id VARCHAR(75) address_2 VARCHAR(200) created DATETIME city VARCHAR(45) description LONGTEXT country CHAR(2) duration INT(11) distance DECIMAL(10,2) event_url VARCHAR (250) lat DECIMAL(10,8) th group_id INT(11) localized_country_name VARCHAR (45) kheadcount INT(11) lon DECIMAL (12,8) how_to_find_us VARCHAR(250) venue_name VARCHAR(300) maybe_rsvp_count INT(11) phone BIGINT(20) event_name VARCHAR (95) state CHAR(2) photo_url VARCHAR(250) zip INT(11) svp_limit INT(11) RANDO) DOUBLE event_status ENUM(...) Indexes event time DATETIME te updated DATETIME utc_offset INT(11) venue_id INT(11) visibility ENUM(...) vaitlist_count INT(11) why VARCHAR(45) yes_ is vp_count INT(11) Indexes city city_id INT(11) city VARCHAR(45) state CHAR(2) zip INT(11) country CHAR(2) localized_country_name VARCHAR (45) distance DECIMAL(12,3) longitude DECIMAL(12,8) latitude DECIMAL(12,8) member_count INT(11) ranking INT(11) Indexes grp group_id INT(11) category_id INT(11) city_id INT(11) created DATETIME description LONGTEXT join_mode ENUM(...) ++ group_name VARCHAR(150) rating DECIMAL(4,2) visibility ENUM(...) members INT(11) who VARCHAR(85) Indexes