Find the categories that no product belongs to directly. Show category_id,
category_name and has_subcategories: true when another category has it as its parent,
otherwise false.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| parent_category_id (FK) |
| products |
|---|
| product_id (PK) |
| category_id (FK) |
Find the categories that no product belongs to directly. Show category_id,
category_name and has_subcategories: true when another category has it as its parent,
otherwise false.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| parent_category_id (FK) |
| products |
|---|
| product_id (PK) |
| category_id (FK) |
| category_id | category_name | has_subcategories |
|---|---|---|
| 9 | All Products | true |
| 10 | Gadgets & Media | true |
| 11 | Lifestyle | true |
| 12 | Home & Family | true |
| 13 | Smart Home | false |
Run query to see output