From the course: Learning SQL Programming
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Practice with JOINs - SQL Tutorial
From the course: Learning SQL Programming
Challenge: Practice with JOINs
(upbeat music) - [Narrator] Now that we've explored JOINs and the grouping of results, let's practice by taking on two challenges. First, let's create a summary of how many hats we need to ship to each state, and then let's count up how many members of each team there are in each of the geographic divisions listed in the states table. This should take about 10 minutes, and when you've put together your queries, come back and I'll show you how I solved these challenges.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.