From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Solution: Final project

Solution: Final project - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Final project

“

- [Instructor] All right, this is the solution video for the final course project. As a reminder, the situation is you and your business partner more recently approached about a possible acquisition. Your objective is to use your SQL skills to extract and analyze the data that you'll need to answer your potential acquirers questions. Let's jump into the solutions. For this first question, we need to get managers names, the store they work at, the full address of each property, including street address, district, city, and country. So what we're doing here is we're pulling staff dot first name from the staff table and staff dot last name also from the staff table. And we're pulling address from the address table. We're pulling district from the address table. We're pulling city from the city table and country from the country table. We start our select from the store table and you can see the various joins that we have to make here. Take a look at the columns that we're using to make…

Contents