From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Challenge: Final project

Challenge: Final project - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Final project

“

- [Presenter] All right, time to introduce your final course project. The situation, you and your business partner have just been approached by another local business owner who's a potential acquirer. He's got a lot of questions about the business and you're going to be the one that will help him out. The objective is to leverage your SQL skills to extract and analyze data from various tables in the Maven Movies database. To answer your acquirer's questions. Each question will require you to write a multi table SQL query, joining at least two tables. Here's the letter from your potential acquirer for some context. I'll let you read through this on your own time, and here are the detailed questions that he's provided as well. There are eight questions in total. I won't run you through them all, but again, I want to note the timestamps here. These are where you can find the solutions in the solution video. And as these questions go on, they get harder. So the first couple in here are…

Contents