Everything Under Gadgets & Media
MediumDescription
Categories form a tree through parent_category_id. Show category_id and
category_name of Gadgets & Media (category_id 10) and of every category below it: its
children, their children, and so on.
End your query with ORDER BY category_id.
Tables
| categories |
|---|
| category_id (PK) |
| category_name |
| parent_category_id (FK) |