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

Unlock the full course today

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

Challenge: Filtering and grouped query

Challenge: Filtering and grouped query - SQL Tutorial

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

Start my 1-month free trial

Challenge: Filtering and grouped query

“

- [Narrator] You need to write a query to report animals and the number of vaccinations each has received. You need to include animals that were never vaccinated but exclude all rabbits, all rabies vaccinations, and all animals that were last vaccinated on or later than October 1st, 2019. The report should return the following attributes. The animal's name, species, primary color and breed. The number of vaccinations that the animal has received. And obviously with zero for animals that were never vaccinated. Your guidelines are to use the minimal number of tables that are required, use the correct logical join types and force order if needed, and use the correct logical group by expressions. Good luck.

Contents