For every category, show category_name and products: the number of products that
belong to it directly, or 0 when it has none.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
For every category, show category_name and products: the number of products that
belong to it directly, or 0 when it has none.
End your query with ORDER BY category_id.
| categories |
|---|
| category_id (PK) |
| category_name |
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| category_name | products |
|---|---|
| Electronics | 6 |
| Books | 5 |
| Clothing | 3 |
| Home & Kitchen | 4 |
| Sports | 4 |
| Beauty | 3 |
| Grocery | 3 |
| Toys | 3 |
| All Products | 0 |
| Gadgets & Media | 0 |
| Lifestyle | 0 |
| Home & Family | 0 |
| Smart Home | 0 |
Run query to see output