For every product whose specs has a ram key, show its whole spec sheet: one row per
key in specs, with product_name, key and value (as text).
End your query with ORDER BY product_name, key.
| products |
|---|
| product_id (PK) |
| product_name |
| specs |
For every product whose specs has a ram key, show its whole spec sheet: one row per
key in specs, with product_name, key and value (as text).
End your query with ORDER BY product_name, key.
| products |
|---|
| product_id (PK) |
| product_name |
| specs |
| product_name | key | value |
|---|---|---|
| Nova X5 Smartphone | brand | Nova |
| Nova X5 Smartphone | ram | 8GB |
| Nova X5 Smartphone | storage | 128GB |
| VoltBook Air 14 Laptop | brand | Volt |
| VoltBook Air 14 Laptop | ram | 16GB |
| VoltBook Air 14 Laptop | storage | 512GB |
Run query to see output