From the course: Advanced SQL: High Performance Relational Divisions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Challenge: Exact relational division - SQL Tutorial
From the course: Advanced SQL: High Performance Relational Divisions
Challenge: Exact relational division
- [Instructor] Your challenge is to modify the query so that candidates with a remainder are eliminated. To put it nicely, I don't want to see Darrin or any other candidate who has more than the required skills. Remember, that an exact division is an ordinary relational division with an additional constraint sprinkled on top. And no aggregates this time, you must use set operators. The code file contains the challenge description, 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.