From the course: Advanced SQL: Logical Query Processing, Part 1
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Hybrid multi-table join - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 1
Challenge: Hybrid multi-table join
- [Instructor] You need to write a query to report all animals and their vaccinations. Animals that have not been vaccinated should be included. The report should include the following attributes, the animal's name, species, breed, and primary color, the vaccination time and the vaccine name, the staff member's first name, last name, and role. The guidelines are to use the minimal number of tables that are required and to use the correct logical join types and force join order as needed. 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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.