Consider the following table: It’s a table of ‘food’ all split into categories, with each sub-category also containing items. A 3-tier hierarchy.
The table is sortable by name, but… what should happen when you sort the Name column?

My…