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

Challenge: Exact relational division - SQL Tutorial

From the course: Advanced SQL: High Performance Relational Divisions

Start my 1-month free trial

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.

Contents