Classify Tree Nodes in SQL
Company: Oracle
Role: Software Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Technical Screen
Overview: Classify each tree node as Root, Inner, or Leaf in PostgreSQL using its parent ID and whether it has children, returning one classification per node.
Read the full Oracle Software Engineer interview experience this question came from