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.

Challenge: SELECT DISTINCT

Challenge: SELECT DISTINCT - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: SELECT DISTINCT

“

- [Instructor] All right, time to test your skills on Select Distinct. For this assignment, your Uncle Jimmy is looking to confirm his understanding that you have titles that you rent for three, five, and seven days. He'd like you to pull the records of the films, and make sure that there aren't any other rental durations. Your result grid will look something like this. Your job is to write the SQL query that will pull the distinct values of rental duration for all of your films. Like we talked about before, please try to work through this on your own, and then come back to the Solution Video. You're going to learn best when you're working through these problems on your own. Thanks, good luck.

Contents