Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Coding Challenge – July 2020

Introduction
Tasks
8. Task 4

Instruction

Fantastic! Your knowledge of US states is growing!

It's time for more complex queries. Let's follow a river.

Exercise

Select the names of the states (name the column state_name) through which the 'Red River' flows.

Stuck? Here's a hint!

Connect the tables river_state, state, and river using the JOIN clause.

You can learn more about joining tables in the JOINs course.