SQLite: Self Join Relations

Link: https://www.meetgor.com/sqlog/sqlite-self-join-relations

Context

Source: techstructive-weekly-60