I still require help. The previously answers providing the breakdowns were unclear to me.

My SQL Workbench

Project Part 2- AD HOC REPORTS

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 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

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.

HINT

You will need to use JOINs to display the events alongside their cities.

The ERD below should help with the joins. Find the keys in common between the grp, city, and event tables.

4. Lastly, write a third query to give the exact counts of Toastmaster events for each particular city.

HINT

You will want to return a COUNT of the events in each city, meaning you will need to GROUP them by city.

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.

lab Tables Views Stored Procedures Functions N Pathstream Lab File Edit View Query Database Server Tools Scripting Help