From the course: Advanced SQL: Logical Query Processing, Part 2

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge

Challenge - SQL Tutorial

From the course: Advanced SQL: Logical Query Processing, Part 2

Start my 1-month free trial

Challenge

- [Instructor] Our shelter has been experiencing financial difficulties. The board of directors decided to explore additional revenue sources and came up with the following idea. Instead of spaying and neutering all animals, the shelter should consider responsible breeding of purebred animals. Your challenge is to figure out which animals are breeding candidates. Candidates should be male and female of the same species and breed and you may use any database that you wish. In the next video I'll review my suggested solutions for both SQL server and Postgres. You will find the requirements, expected results and some helpful tips and the code file for this chapter. Good luck.

Contents