In this exercise, write a query to solve a challenge that involves a self join.
- [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. … …
This course was created by Ami Levin. We are pleased to offer this training in our library.
Skill Level Advanced
1. Subqueries and Set Operators
2. Advanced Joins
3. More on Grouping
4. Recursions and Cursors
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.