Whenever you're ready, walk me through how you'd approach this.
What are join tiers in SQL?
Explain what the term usually means, noting that it is not a formal SQL standard. Describe how joins may be categorized by complexity, distinguish tiers from join types such as INNER JOIN and LEFT JOIN, and explain the practical trade-offs of more complex join logic.