https://www.sqlservertutorial.net/sql-server-basics/sql-server-left-join/
Anonymous
Think hierarchically.