Question: 2. Provide one insight per table along with your SQL code. In the 2_additional_insights.sql file you will find and report at least one insight for

2. Provide one insight per table along with your SQL code. In the 2_additional_insights.sql file you will find and report at least one insight for each of six tables in the LetsMeet database. These tables include: venue_ grp grp_member city event category Explore the data using the SQL queries you learned thus far. Here is the ERD diagram that Quinn has provided for your review. Letsmeet erd To get you started, here are a few guiding questions for each table below. VENUE_ What is the RAND() column in this table? Does it have any relation to the venues? Which city has the most venues? Which zip code has the most venues? What neighborhood is this? GRP What is the longest running group on LetsMeet? How many members do they have? What does public_limited mean? How many groups are public_limited? You notice the who column. What values come up most frequently in the who column? GRP_MEMBER Who was the first LetsMeet member that is still active? What member is a part of the most groups? Can you use this table to determine the total number of members? Why or why not? CITY What is the ranking column? Is it providing any additional useful information about cities? EVENT What is the average duration of all events? In minutes? Hours? Which venue is the most popular and how many events were held there? CATEGORY How can you combine the category data with other data to determine the most popular categories

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!