MySQL Project Part 2 – Ad Hoc Reporting

Project 2 Overview
Project Overview
Project Part 2 – Ad Hoc Reporting
As an analyst, you are likely to receive a number of one-off requests to provide answers to a variety of business questions. These requests can be time-sensitive and demand that you turn around a summary of your findings quickly. You will also have to juggle a number of these requests at the same time. This means that the deliverable for these types of ad hoc requests will usually be a short and concise summary of your findings. These short reports can include recommendations or insights if requested, but in other cases, they will only require hard numbers or other factual findings.
This style of analysis allows you to extract insights from smaller sections of data as needed to answer more defined and focused business questions. It allows you to formulate specific insights for your organization when they are needed, as opposed to a more formal report such as a presentation or quarterly newsletter”
In this Project Part, you will respond to multiple ad hoc requests from varying teams or persons in the LetsMeet organization. You will write a series of queries to answer their questions and summarize your findings in the provided 1_summary_report.sql file.
The goal of this project is to help you get comfortable breaking down and responding to an ad hoc request. You will be given guiding questions and instructions to assist you in thinking through the asks and to help guide the queries you are writing.
Summary Report Examples
The following are three examples of ad hoc requests you might get as an analyst and examples of how you might communicate your findings (Note: These are not the same requests you will respond to in the project). In the real world, these short reports would likely be included in an e-mail, but for the sake of this Project, you will organize your findings as multi-line comments in a SQL file.
REPORTING JUST THE FACTS:
The Request:
Good morning!
I need to send a quick status update to our Growth Team this morning on how our groups are doing. I’d like to know the average, minimum, and maximum number of members in our LetsMeet groups.
Thanks for your help!
Cat
The Report:
Since Cat simply asked you to report back with some numbers, your response might include a bullet-pointed list like the following:
— On average how many members do LetsMeet groups have?
/*
– LetsMeet groups have an average of 732 members.
– The group with the most members currently has 23380 members.
– The group with the least members currently has 1 member.
*/
REPORTING QUICK INSIGHTS:
The Request:
Hey there,
Engineering is looking into a bulk event uploading feature to support some of our more active groups, but before they add the feature they need some information. Do you have any insights into how LetsMeet groups are uploading their events currently?
Look forward to hearing your thoughts!
Isabella
The Report:
Isabella didn’t provide too many details about the numbers she is interested in but did ask you to provide some insights into how users are uploading their events. After performing a short exploratory analysis, the information you communicate back to her might look something like the following snippet:
— How are LetsMeet groups creating their events? In bulk or one at a time?
/*
– A significant number of groups are creating multiple events on a single day.
– The most common number of events created per day is approximately 50.
– There appears to be a relationship between the number of events a group hosts and the number of
events they upload at one time.
– Groups creating 50 events in a day typically host more events overall.
– Groups with less frequently occurring events typically create them one at time.
*/
MAKING A RECOMMENDATION:
The Request:
Hi again! Thanks for the information on your bulk event uploading findings. As a follow-up, can you make some recommendations on groups we should target for beta testing the bulk event uploading feature? I’d love to hear your thoughts once you’ve had a chance to dig deeper into the data. Can you get this to me by EOD today?
Thanks again,
Isabella
The Report:
In this case, you need to not only provide insights into the data but also make recommendations based on your findings. This might look something like the following:
— Recommendations for beta testing
/*
– Chicago Area Toastmasters.
– They have created the most events of any of the groups of LetsMeet.
– They have created 1061 events.
– They frequently upload 50 events at a time
– Business Events NY group.
– They have fewer events overall at 36.
– They have been bulk uploading their events consistently in groups of 12.
– Perhaps this feature could encourage them to host more events.
– Alternative Fun Stuff To Do NYC.
– They have created 17 events in total.
– Each event was created on a different day.
– Based on the data, they are consistently creating regular events and may be good candidates for
bulk uploading.
*/
Ready, Set, Report!
You’re now ready to start answering your own ad hoc requests. Time to open up your inbox and MySQL workbench and start analyzing!
Start Project
Ready, Set, Report!
You’re now ready to start answering your own ad hoc requests. Time to open up your inbox and MySQL workbench and start analyzing!
The Requests
Your LetsMeet inbox is filling up quickly with requests for data and insights!
You currently have three requests in your inbox awaiting your response:
The LetsMeet CEO Evelyn wants to know how many Toastmasters events are occurring in each city.
The Growth team wants to know if membership is leveling off, and if so, why.
The Marketing team is looking for recommendations on groups to feature in an upcoming campaign.
Each of these requests will require a different level of analysis and insights or recommendations. Follow the instructions in each of the steps below to write queries and respond to the requests accordingly.
While completing your project, stop every now and then to save your work. This will ensure that your work won’t be lost!
Request #1: Toastmasters Events ????
The first e-mail in your inbox is from the CEO Evelyn.
Good Morning,
As you might have heard around the office, I’m an avid member of Toastmasters, an international public speaking organization. I have a presentation at our local Chicago event tonight and I want to add some figures to my slides to emphasize the connection between Toastmasters and LetsMeet. Can you get back to me with the following by this afternoon:
– The total number of Toastmasters events on Lets Meet
– The number of Toastmasters events per city.
I really appreciate this!
Evelyn
This request seems straightforward, so it’s time to get down to work!
To get started, follow these steps:
1. Navigate to 2_toastmaster.sql
DON’T SEE 2_TOASTMASTER.SQL? CREATE THE SQL FILE YOURSELF.
2. To begin with, you should find all the events that include the word, Toastmaster. You can use string manipulation to return all event names that include “Toastmaster” or “toastmaster.”
3. Now that you have the Toastmasters events, write a second query to display them alongside the cities in which they are hosted.
4. Lastly, write a third query to give the exact counts for how particular cities host Toastmasters events.
5. Save your script by clicking File > Save Script
5. Return to 1_summary_report.sql and summarize your findings for Evelyn. Since she only asked for the hard numbers, there is no need to provide additional recommendations or insights.
Request #2: Leveling Off Of Member Growth ????
The next request in your inbox is from a member of the LetsMeet Growth team. They are part of the Sales team that is responsible for growing the membership of LetsMeet year-over-year.
Hey there,
I’m working on a report on membership growth to date for Cat and after scanning the latest numbers noticed that it appears membership growth might be leveling off.
I’m wondering if you can dig into the year-over-year membership growth for the whole organization. I’m worried there might be some errors in our data collection.
Engineering has already informed me of at least one error regarding the city information in our grp_member table. It looks like you might need to amalgamate some smaller suburbs into into their wider geographic area (i.e. East Chicago and West Chicago should just be Chicago). I’ll send you an attachment with our required breakdown.
Please include any insights into why membership doesn’t seem to be growing like it used to.
Let me know if you can get to this by end of day.
Cheers,
Sammy
In their follow up e-mail Sammy included a helpful reminder that the joined column in the grp_member table represents the date a member joined a specific group, not the date they joined LetsMeet. They suggest instead that you use the date a member joined their first group as a proxy for when they joined the site.
To get started, follow these steps:
1.Navigate to the SQL file named 3_growth.sql.
DON’T SEE 3_GROWTH.SQL? CREATE THE SQL FILE YOURSELF.
2. Write a query that shows the growth of LetsMeet over the years based on the number of members who joined each year.
HINT
3. In the grp_member table, use the appropriate DML to rename the smaller cities to the name of their larger urban areas. Based on the attachment from Sammy, they should be combined as follows:
Chicago – East Chicago, West Chicago, North Chicago, Chicago Heights, Chicago Ridge, Chicago
San Francisco – San Francisco, South San Francisco
New York – New York, West New York
HINT
4. Time to see if there are any differences in year over year growth by city! Write three new queries that show the annual growth of LetsMeet for the larger geographical areas of Chicago, San Francisco, and New York.
HINT
5. You decide you want to dig deeper into membership growth specifically in 2017, the year when growth in membership seems to slow the most. Write a query to examine the month by month growth for LetsMeet in 2017. What do you notice about the resulting table?
HINT
6. Save your script by clicking File > Save Script
7. Return to 1_summary_report.sql and summarize your findings for the Growth Team in a few bullet points. This should include your overall findings on year-over-year growth and insights into why membership growth appears to be leveling off, including any potential data anomalies.
Request #3: Marketing Campaign Recommendations ????
You’re so close to clearing your inbox! The last request you need to address is from marketing.
Afternoon,
We are working on an exciting new marketing campaign for LetsMeet to attract new groups to the platform.
We are hoping to feature five groups in the campaign that really showcase the popularity and diversity of the LetsMeet group community.
Are you able to recommend groups for us to feature? Ideally the groups selected:
– Are highly rated.
– Have a significant number of members.
– Are representative of a variety of categories.
I’m looking for recommendations for three groups from New York, one from Chicago and one from San Francisco.
If you can send me your recommendations and supporting data by end of week, that would be greatly appreciated!
Yan
It sounds like the marketing team hopes this campaign will expand the number and the variety of groups on the platform!
It’s a big ask, but you’re on it!
To get started, follow these steps:
1. Navigate to the SQL file named 4_feature_groups.sql.
2. You should start by examining the breakdown of ratings to determine if it’s a reliable measure of group popularity.
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
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?
2. 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.
3. Adjust your previous query to include the city for each group to ensure you are selecting three groups: one from New York, one from Chicago, and one from San Francisco.
HINT
4. 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?
5.Save your script by clicking File > Save Script
6. Return to 1_summary_report.sql and make your recommendations to the Marketing Team. Each group recommendation you make should include the data to support how that particular group meets the requirements of the marketing team’s campaign.
You Did It! ????
You are officially at Inbox Zero!
You should have four SQL files to submit:
1_summary_report.sql
2_toastmasters.sql
3_growth.sql
4_feature_groups.sql
Project, Part 2 – Ad Hoc Reports RubricsExceed (A)Achieve (B)Emerging (C)Incomplete (D/F)
1
File Organization
Required files are present and appropriately named. * 1_summary_work * 2_toastmaster * 3_growth * 4_feature_groups
Required files are present and appropriately named, with some exceptions. * 1_summary_work * 2_toastmaster * 3_growth * 4_feature_groups
Required files are present and appropriately named with several exceptions. * 1_summary_work * 2_toastmaster * 3_growth * 4_feature_groups
Required files are missing or are not appropriately named.
2
Query Correctness
All queries run without error and produce the correct output.
Most queries run without error and produce the correct output most of the time.
Some queries run without error and produce the correct output some of the time.
Queries are missing or do not run properly. Output is missing or is incorrect.
3
SQL Syntax Best Practices
SQL Syntax always uses the following best practice guidelines: * Capitalization * Indentation and line breaks * Semicolons
SQL Syntax mostly uses the following best practice guidelines: * Capitalization * Indentation and line breaks * Semicolons
SQL Syntax sometimes uses the following best practice guidelines: * Capitalization * Indentation and line breaks * Semicolons
SQL Syntax does not adhere to best practice guidelines.
4
Insights and Recommendations
Insights and recommendations are: * Clear and concise * Relevant * Properly formatted * Supported by data
Insights and recommendations are mostly: * Clear and concise * Relevant * Properly formatted * Supported by data
Insights and recommendations are sometimes: * Clear and concise * Relevant * Properly formatted * Supported by data
Insights are missing or are unclear, inaccurate, irrelevant, or not supported by data.
5
Comments
Comments describe each query’s purpose and adhere to the following guidelines (when necessary): * Multi-line * Wrapped
Comments mostly describe each query’s purpose and adhere to the following guidelines (when necessary) with some exceptions: * Multi-line * Wrapped
Comments partially describe each query’s purpose and adhere to the following guidelines (when necessary), with several exceptions: * Multi-line * Wrapped
Comments are missing or do not describe each query’s purpose and do not adhere to the guidelines (when necessary).
sqlmysql
ATTACHED FILE(S)
Project 2 Overview
Project Overview
Project Part 2 – Ad Hoc Reporting
As an analyst, you are likely to receive a number of one-off requests to provide answers to a variety of business questions. These requests can be time-sensitive and demand that you turn around a summary of your findings quickly. You will also have to juggle a number of these requests at the same time. This means that the deliverable for these types ofad hocrequests willusually be a short and concise summary of your findings. These short reports can include recommendations or insights if requested, but in other cases, they will only require hard numbers or other factual findings.
This style of analysis allows you to extract insights from smaller sections of data as needed to answermore defined and focused business questions. It allows you to formulate specific insights for your organization when they are needed, as opposed to amore formal report such as a presentation or quarterly newsletter”
In this Project Part, you will respondto multiple ad hoc requests from varying teams or persons in the LetsMeet organization. You will write a series of queries to answer theirquestions and summarize your findings in the provided
1_summary_report.sql
file.
The goal of this project is to help you get comfortable breaking down and respondingto an ad hoc request. You will be given guiding questions and instructions to assistyou in thinking through the asks and to help guide the queries you are writing.
Summary Report Examples
The following are threeexamples ofad hoc requests you might get as an analyst and examples of how you might communicate your findings (Note: These are not the same requestsyou will respondto in the project). In the real world, theseshort reports would likely be included in an e-mail, but for the sake of this Project, you will organizeyour findings as multi-line comments in a SQL file.
REPORTING JUST THE FACTS:
The Request:
Good morning!
I need to send a quick status update to our Growth Team this morning on how our groups are doing. I’d like to know the average, minimum, and maximum number of members in our LetsMeet groups.
Thanks for your help!
Cat
The Report:
Since Cat simply asked you to report back with some numbers, your response might include a bullet-pointed list like the following:
— On average how many members do LetsMeet groups have?
/*
– LetsMeet groups have an average of 732 members.
– The group with the most members currently has 23380 members.
– The group with the least members currently has 1 member.
*/
REPORTING QUICK INSIGHTS:
The Request:
Hey there,
Engineering is looking into a bulk event uploading feature to support some of our more active groups, but before they add the feature they need some information. Do you have any insights into how LetsMeet groups are uploading their events currently?
Look forward to hearing your thoughts!
Isabella
The Report:
Isabella didn’t provide too many details about the numbers she is interested in but did ask you to provide some insights into how users are uploading their events. After performing a short exploratory analysis, the information you communicate back to her might look something like the following snippet:
— How are LetsMeet groups creating their events? In bulk or one at a time?
/*
– A significant number of groups are creating multiple events on a single day.
– The most common number of events created per day is approximately 50.
– There appears to be a relationship between the number of events a group hosts and the number of
events they upload at one time.
– Groups creating 50 events in a day typically host more events overall.
– Groups with less frequently occurring events typically create them one at time.
*/
MAKING A RECOMMENDATION:
The Request:
Hi again! Thanks for the information on your bulk event uploading findings. As a follow-up, can you make some recommendations on groups we should target for beta testing the bulk event uploading feature? I’d love to hear your thoughts once you’ve had a chance to dig deeper into the data. Can you get this to me by EOD today?
Thanks again,
Isabella
The Report:
In this case, you need to not only provide insights into the data but also make recommendations based on your findings. This might look something like the following:
— Recommendations for beta testing
/*
– Chicago Area Toastmasters.
– They have created the most events of any of the groups of LetsMeet.
– They have created 1061 events.
– They frequently upload 50 events at a time
– Business Events NY group.
– They have fewer events overall at 36.
– They have been bulk uploading their events consistently in groups of 12.
– Perhaps this feature could encourage them to host more events.
– Alternative Fun Stuff To Do NYC.
– They have created 17 events in total.
– Each event was created on a different day.
– Based on the data, they are consistently creating regular events and may be good candidates for
bulk uploading.
*/
Ready, Set, Report!
You’re now ready to start answering your own ad hoc requests. Time to open up your inbox and MySQL workbench and start analyzing!
Start Project
Ready, Set, Report!
You’re now ready to start answering your own ad hoc requests. Time to open up your inbox and MySQL workbench and start analyzing!
The Requests
Your LetsMeet inbox is filling up quickly with requests for data and insights!
You currently have three requests in your inbox awaiting your response:
1. The LetsMeet CEO Evelyn wants to know how many Toastmasters events are occurring in each city.
2. The Growth team wants to know if membership is leveling off, and if so, why.
3. The Marketing team is looking for recommendations on groups to feature in an upcoming campaign.
Each of these requests will require a different level of analysis and insights or recommendations. Follow the instructions in each of the steps below to write queries and respond to the requests accordingly.
While completing your project,stop every now and then to save your work.This will ensurethat your work won’t be lost!
Request #1: Toastmasters Events馃摤
The first e-mail in your inbox is from the CEO Evelyn.
Good Morning,
As you might have heard around the office, I’m an avid member of Toastmasters, an international public speaking organization. I have a presentation at our local Chicago event tonight and I want to add some figures to my slides to emphasize the connection between Toastmasters and LetsMeet. Can you get back to me with the following by this afternoon:
– The total number of Toastmasters events on Lets Meet
– The number of Toastmasters events per city.
I really appreciate this!
Evelyn
This request seems straightforward, so it’s time to get down to work!
To get started, follow these steps:
1. Navigate to2_toastmaster.sql
DON’T SEE 2_TOASTMASTER.SQL? CREATE THE SQL FILE YOURSELF.
2. To begin with, you should find all the events that include the word, Toastmaster. You can usestring manipulation to return all event names that include “Toastmaster” or “toastmaster.”
3. Now that you have the Toastmasters events, write a second queryto display them alongside the cities in which they are hosted.
4. Lastly, write a third query to give the exact counts for how particular cities hostToastmasters events.
5. Save your script by clickingFile > Save Script
5. Return to1_summary_report.sqland summarize your findings for Evelyn. Since she only asked for the hard numbers, there is no need to provide additional recommendations or insights.
Request #2: Leveling Off Of Member Growth 馃摤
The next request in your inbox is from a member of the LetsMeet Growth team. They are part of the Sales team that is responsible for growing the membership of LetsMeet year-over-year.
Hey there,
I’m working on a report on membership growth to date for Cat and after scanning the latest numbers noticed that it appears membership growth might be leveling off.
I’m wondering if you can dig into the year-over-year membership growth for the whole organization. I’m worried there might be someerrors in our data collection.
Engineering has already informed me of at least one error regarding the city information in ourgrp_membertable. It looks like you might need to amalgamate some smaller suburbs into into their wider geographic area (i.e. East Chicago and West Chicago should just be Chicago). I’ll send you an attachment with our required breakdown.
Please include any insights into why membership doesn’t seem to be growing like it used to.
Let me know if you can get to this by end of day.
Cheers,
Sammy
In their follow up e-mail Sammyincludeda helpful reminder that thejoinedcolumnin thegrp_membertable represents the date a member joined a specific group, not the date they joined LetsMeet. They suggest instead that you use the date a member joined their first group as a proxy for when they joined the site.
To get started, follow these steps:
1.Navigate to the SQL file named3_growth.sql.
DON’T SEE 3_GROWTH.SQL? CREATE THE SQL FILE YOURSELF.
2. Write a query that shows the growth of LetsMeet over the years based on the number of members who joined each year.
HINT
3. In the grp_member table, use the appropriate DML to rename the smaller cities to the name of their larger urban areas. Based on the attachment from Sammy, they should be combined as follows:
路 Chicago- East Chicago, West Chicago, North Chicago, Chicago Heights, Chicago Ridge, Chicago
路 San Francisco- San Francisco, South San Francisco
路 New York- New York, West New York
HINT
4. Time to see if there are any differences in year over year growth by city! Write threenew queriesthat show the annual growth of LetsMeetfor the larger geographical areas of Chicago,San Francisco, and New York.
HINT
5. You decide you want to dig deeper into membership growth specifically in 2017, the year when growth in membership seems to slow the most. Write a query to examine the month by month growth for LetsMeet in 2017. What do you notice about the resulting table?
HINT
6. Save your script by clickingFile > Save Script
7. Return to1_summary_report.sqland summarize your findings for the Growth Team in a few bullet points. This should include your overall findings on year-over-year growth and insights into why membership growth appears to be leveling off, including any potential data anomalies.
Request #3: Marketing Campaign Recommendations 馃摤
You’re so close to clearing your inbox! The last request you need to address is from marketing.
Afternoon,
We are working on anexciting new marketingcampaign for LetsMeet to attract new groups to the platform.
We are hoping to feature five groups in the campaign that really showcase the popularity and diversity of the LetsMeet group community.
Are you able to recommend groups for us to feature? Ideally the groups selected:
– Are highly rated.
– Have a significant number of members.
– Are representative of a variety of categories.
I’m looking for recommendations for three groups from New York, one from Chicago and one from San Francisco.
If you can send me your recommendations and supporting data by end of week, that would be greatly appreciated!
Yan
It sounds like the marketing team hopes this campaign willexpand the number andthe variety of groups on the platform!
It’s a big ask, but you’re on it!
To get started, follow these steps:
1. Navigate to the SQL file named 4_feature_groups.sql.
2. You should start by examining the breakdown of ratings to determine if it’s a reliable measure of group popularity.
Write a query to break down thegroups 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 theratingscolumn of thegrptable.
HINT
Guiding Questions To Consider
路 How many groups have 5 star ratings?
路 Of the groups that have been rated, what percentof groups are rated 5 stars?
路 Is this a reliable measure of the success or popularityof the group?
2. Instead of focusing on rating alone, you should also look at membership numbers. Of the groups who have perfect 5 star ratings, writea query to find those with the most members.
3. Adjust your previous query to include the city for each group to ensure you are selecting three groups: one from New York, one from Chicago, and one from San Francisco.
HINT
4. 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 includingonly groups from the least represented categories to try and increase the variety of groups on LetsMeet?
5.Save your script by clickingFile > Save Script
6. Return to1_summary_report.sqland make your recommendations to the Marketing Team. Each group recommendationyou make should include the data to support how thatparticular group meets the requirements of the marketing team’s campaign.
You Did It! 馃挭
You are officially at Inbox Zero!
You should have four SQLfiles to submit:
1.
1_summary_report.sql
2.
2_toastmasters.sql
3.
3_growth.sql
4.
4_feature_groups.sql
— Summary of Findings
— Use this file to summarize your findings and make your recommendations where they have been requested.
— Any recommendations should include the data to support why you are making that recommendation
— 1. How many Toastmasters events are there using LetsMeet in New York, Chicago and San Francisco?
— 2. Is LetsMeet membership leveling off?
— 3. What five groups should marketing feature in their upcoming campaign?*
4_feature_groups.sql
1_summary_report.sql
— Summary of Findings
— Use this file to summarize your findings and make your recommendations where they have been requested.
— Any recommendations should include the data to support why you are making that recommendation
— 1. How many Toastmasters events are there using LetsMeet in New York, Chicago and San Francisco?
— 2. Is LetsMeet membership leveling off?
— 3. What five groups should marketing feature in their upcoming campaign?*
__MACOSX/._1_summary_report.sql
2_toastmaster.sql
3_growth.sql
TBDA.2 Project 2 Adhoc Report Answer
Questions to Answer
2_toastmaster.sql file
The LetsMeet CEO Evelyn wants to know how many Toastmasters events are occurring in each city.
— Part A.
SELECT * FROM event AS e;
/* The query about fetches all events from the event table that includes the even_name Toastmasters or Toastmasters. */
QUERY 1
— Find all events that include the word Toastmaster or toastmaster in LetsMeet.
QUERY 2
— 2. The Total number of Toastmasters events on the LetsMeet
QUERY 3
— 3. Write a query to give the exact counts for how particular cities host Toastmasters events.
Query 4
— 4. How many Toastmasters events are there using LetsMeet in New York, Chicago and San Francisco?
3_growth.sql file
SELECt * FROM grp_member;
— 1. Query for the Number of members who joined each year.
— 2. Query for the Number of members who joined each year.
— 3. Find the total number of members joined in cities like New York, Chicago, and San Francisco.
Query 3 Solved
–4.Use appropriate DML to rename the small cities to the name of their larger urban areas
SET SQL_SAFE_UPDATES = 0;
UPDATE grp_member
SET city = “Chicago”
WHERE city IN(“East Chicago”, “West Chicago”, “North Chicago”, “Chicago Heights”, “Chicago Ridge”, “Chicago”);
SET SQL_SAFE_UPDATES = 1;
SELECT * FROM grp_member;
SET SQL_SAFE_UPDATES = 0;
UPDATE grp_member
SET city = “San Francisco”
WHERE city IN(“San Francisco”, “South San Francisco”);
SET SQL_SAFE_UPDATES = 1;
SELECT * FROM grp_member;
SET SQL_SAFE_UPDATES = 0;
UPDATE grp_member
SET city = “New York”
WHERE city IN(“New York”, “West New York”);
SET SQL_SAFE_UPDATES = 1;
/* The SQL queries above aimed at renaming small cities to th name of their larger urban are. */
— 5. Write three queries that shows that the annual growth of Letsmeet for the larger geographical areas of chicago, San Francisco and New York.
— – 6.Write a Query that shows that the annual growth of Letsmeet for the larger geographical Chicago.
— 7. Write to find out number of members joined LetsMeet on Month by month in 2017
Feature_group.sql File
SELECT * FROM grp;
— Query 1
— Total number of groups from the grp table of LetsMeet.
SELECT COUNT(*) AS grp_total FROM grp;
/* This SQL query above counts the total number of groups from the grp table as grp_total which is 4340. */
-Query 2
— 1 A.The Number of groups with 5-stars ratings
B.Of the groups that have been rated, what percentage of groups are rated 5 stars?
— 2. Write a query to find those groups with the most members.
3. Is this a reliable measure of the success or popularity of the group? Yes
Summary Report
— Summary of Findings
/* Summary from 2_toastmaster

Summary rport from 3_growth file

Summary report from 4_feature_groups.sql file

*/
— Use this file to summarize your findings and make your recommendations where they have been requested.
/*
*/
— Any recommendations should include the data to support why you are making that recommendation
/*
*/
— 1. How many Toastmasters events are there using LetsMeet in New York, Chicago and San Francisco?
/*
— 2. Is LetsMeet membership leveling off?
/*
*/
— 3. What five groups should marketing feature in their upcoming campaign?*
/*
*/

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer鈥檚 samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That鈥檚 why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more