From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Solution: Mid-course project

Solution: Mid-course project - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Mid-course project

“

- [Instructor] All right, this is the solution video for the Mid Course Project. As a reminder, the company's insurance policy is up for renewal, and the underwriter has a number of questions that he needs answered before he can issue a new policy. Your objective is going to be to use MySQL to leverage your skills to extract and analyze all the data that's needed to answer the underwriter's questions. Let's jump into the solution now. For this first question, we're going to need a list of all staff members, including their first and last names, email addresses, and the store identification number where they work. We can get all of this data from the staff table, and we'll be selecting first name, last name, email, and store ID. We make sure that all our column names are separated by commas, and when we run the query, we can see what's happening. We've got first name, last name, and email, and we have the two store managers listed here. Hopefully that one is pretty straightforward…

Contents