Question: Provide one insight per table along with your SQL code. In the 2 _ additional _ insights.sql file you will find and report at least
Provide one insight per table along with your SQL code.
In the
additionalinsights.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
grpmember
city
event
category
Explore the data using the SQL queries you learned thus far. Here is the ERD diagram that
grad mydb
Tables
Views
Routine Groups
lab
Quinn has provided for your review.
Download files
VENUE
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?
GRPMEMBER
Who was the first LetsMeet member that is still active? What member is a part of the most groups?
CITY
What is the ranking column? Is it providing any additional useful information about cities?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
