Hierarchical Queries

You’ll quite often encounter data that is organized into a hierarchy, such as the people who work in a company, a family tree, or the parts that make up an engine. In this section, you’ll learn how to perform queries against a table that stores the employees who work for the example store.

The Example Data

You’ll see the use of a table named more_employees, which is created by the store_schema.sql script as follows: