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: Mid-course project

Challenge: Mid-course project - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Mid-course project

“

- [Instructor] Now it's time to introduce your Mid-Course Project. The situation is, the company's insurance policy is up for renewal, and the underwriter needs some updated information, otherwise they won't be able to renew your policy. Your objective is to leverage your SQL skills to extract and analyze data from various tables in the Maven Movies database so that you can answer the underwriter's question. Each question can be answered by querying just one table. Part of your job as an analyst is figuring out which table to use. You can read through this letter from the underwriter to get a little more context, and then refer to this list of questions that were detailed in the underwriter letter. I won't walk through each of these questions, but I want to note that we have timestamps here so that if you're trying to figure out where the solution is in the Solution Video, then you can just jump right to the timestamp for a specific question. We've got eight questions in total. All of…

Contents