Challenge! �

Overview

• General Challenge Tasks utilizing all the skills you’ve learned so far!
• Hints to the challenge
• Solution to the challenge

​

• Challenges are going to be difficult, so try breaking down the problem into individual tasks!

Challenge

• How many payment transactions were greater than $5.00?

Hints

You will need to use the payment table

You will also need to use COUNT and WHERE along with some comparison operator

SOLUTION

SELECT COUNT(amount) FROM payment

WHERE amount > 5;

Challenge

• How many actors have a first name that starts with the letter P?

Hints

You will need to use the actor table

You will also need to use LIKE and a wildcard operator, such as % or _

SOLUTION

SELECT COUNT(*) FROM actor

WHERE first_name LIKE 'P%';

Challenge

• How many unique districts are our customers from?

Hints

You will need to use the address table

You will also need to use COUNT and DISTINCT

SOLUTION

SELECT COUNT(DISTINCT(district))

FROM address;

Challenge

• Retrieve the list of names for those distinct districts from the previous question.

Hints

You will again need to use the address table

This will be very similar to the previous challenge

SOLUTION

SELECT DISTINCT(district) FROM address;

Challenge

• How many films have a rating of R and a replacement cost between $5 and $15?

Hints

You will need to use the film table.

You may also need to use BETWEEN and a WHERE statement with a comparison operator.

SOLUTION

SELECT COUNT(*) FROM film

WHERE rating = 'R'

AND replacement_cost BETWEEN 5 AND 15;

Challenge

• How many films have the word Truman somewhere in the title?

Hints

You will need to use the film table

You will also need to use LIKE with a wildcard operator

SOLUTION

SELECT COUNT(*) FROM film

WHERE title LIKE '%Truman%';

Great job!

• Let’s go learn some more!