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 - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 2
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.
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.