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: Implement CTE

Try it: Implement CTE - SQL Tutorial

From the course: Practice It: Advanced SQL

Start my 1-month free trial Buy for my team

Try it: Implement CTE

“

(keyboard tapping) - [Instructor] In our first CTE's challenge, you'll need to create a CTE to identify suppliers who provide products with a unit price above the average unit price across all products. Retrieve the supplier name and the number of such high value products they supply. You can execute your code in the setup_script file under the CTEs folder in your Codespace. Go ahead and try it yourself, and in the next video I'll walk you through my solution. Good luck.

Contents