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] Your last challenge for this course is to write a query that returns a statistical report about vaccinations. The report should include the total number of vaccinations for several dimensions. How many were done and each year for each species, for each species per year, by each staff member and by each staff member per species. And to make it a bit more interesting, let's throw in the latest vaccination year for each of these groups as well on top of the count. You'll find their requirements, expected results and some helpful tips and the code file, 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.