From the course: Practice It: Advanced SQL

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Try it: Subquery with conditional logic

Try it: Subquery with conditional logic - SQL Tutorial

From the course: Practice It: Advanced SQL

Start my 1-month free trial Buy for my team

Try it: Subquery with conditional logic

“

(screen beeps) - [Narrator] In our second subquery challenge, you'll need to find employees who have the highest salary within each department, excluding the IT department. You can execute your code in the setup_script file under the subqueries folder in your code space. Go ahead and try it yourself, and in the next video, I'll walk you through my solution. Good luck.

Contents