From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Challenge: Bridging tables

Challenge: Bridging tables - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Bridging tables

“

- [Instructor] All right, you're ready to test your skills on Bridging. For this assignment, your business partner, Uncle Jimmy, has mentioned that your customers are asking which films their favorite actors appear in. It would be great if you guys had a list of all actors with each title that they appear in. He wants you to pull that list, and because the table that you're going to get the actor info and the table that you're going to get the title info from don't directly connect, you're going to need to employ a bridge. Your output should look like this, with actor first name, actor last name, and all of the titles that they appear in. If you're having trouble with this, I would recommend going back and watching the lecture on bridging again, and then try to do this on your own. It's a very similar concept. Try to get the answer yourself, then come back and watch the Solution Video. Good luck.

Contents