Categories form a tree: parent_category_id points to another row of categories. For
every category, show category_name and parent_name: the name of its parent category, or
(top level) when it has no parent.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| parent_category_id (FK) |
Categories form a tree: parent_category_id points to another row of categories. For
every category, show category_name and parent_name: the name of its parent category, or
(top level) when it has no parent.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| parent_category_id (FK) |
| category_name | parent_name |
|---|---|
| Electronics | Gadgets & Media |
| Books | Gadgets & Media |
| Clothing | Lifestyle |
| Home & Kitchen | Home & Family |
| Sports | Lifestyle |
| Beauty | Lifestyle |
| Grocery | Home & Family |
| Toys | Home & Family |
| All Products | (top level) |
| Gadgets & Media | All Products |
| Lifestyle | All Products |
| Home & Family | All Products |
| Smart Home | Electronics |
Run query to see output