From the course: Advanced SQL: High Performance Relational Divisions
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
Challenge: Exact relational division - SQL Tutorial
From the course: Advanced SQL: High Performance Relational Divisions
Challenge: Exact relational division
- [Narrator] Your challenge is to modify the relational division query so that it eliminates candidates with a remainder. To put it nicely, I don't want to see Darrin or any other candidate who has more skills than what's required for the role. I remind you that an exact division is an ordinary relational division with an additional constraint sprinkled on top. The code file contains the challenge, expected results and some helpful hints. Good luck.
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.