Such procedures may analyze, from a hierarchical perspective, data that is above and below the data associated with the query request, and may aggregate the resulting information.
The SQL query may analyze the metadata associated with a database.