Clothing lists its sizes in specs, such as {"sizes": ["M", "L", "XL"]}. For the
products that come in size L, list every size they come in: product_name and size, one row
per size.
End your query with ORDER BY product_name, size.
| products |
|---|
| product_id (PK) |
| product_name |
| specs |
Clothing lists its sizes in specs, such as {"sizes": ["M", "L", "XL"]}. For the
products that come in size L, list every size they come in: product_name and size, one row
per size.
End your query with ORDER BY product_name, size.
| products |
|---|
| product_id (PK) |
| product_name |
| specs |
| product_name | size |
|---|---|
| Cotton Kurta - Navy | L |
| Cotton Kurta - Navy | M |
| Cotton Kurta - Navy | S |
| Cotton Kurta - Navy | XL |
| Denim Jacket | L |
| Denim Jacket | M |
| Denim Jacket | XL |
Run query to see output