specs is a JSONB document such as {"brand": "Nova", "ram": "8GB"}. For each product,
show product_name, brand (the brand from specs as text, NULL when there is none) and
price_rupees (the price as an integer).
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
| specs |
specs is a JSONB document such as {"brand": "Nova", "ram": "8GB"}. For each product,
show product_name, brand (the brand from specs as text, NULL when there is none) and
price_rupees (the price as an integer).
End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| price |
| specs |
| product_name | brand | price_rupees |
|---|---|---|
| Nova X5 Smartphone | Nova | 24999 |
| VoltBook Air 14 Laptop | Volt | 68990 |
| BassBoom Headphones | BassBoom | 2999 |
| PixelTab 11 Tablet | PixelTab | 32999 |
| The Alchemist | NULL | 350 |
| Atomic Habits | NULL | 899 |
| UPSC Mains Guide 2026 | NULL | 1299 |
| Midnight Mystery Novel | NULL | 499 |
| Classic White Sneakers | Stride | 1999 |
| Denim Jacket | UrbanThread | 2499 |
| Cotton Kurta - Navy | DesiWeave | 1299 |
| Steel Pressure Cooker 5L | KitchenPro | 2199 |
| Ceramic Dinner Set (18pc) | HomeLuxe | 3499 |
| Air Fryer 4.5L | NULL | 8999 |
| Yoga Mat Pro 6mm | FlexFit | 999 |
| Cricket Bat - Kashmir | SportKing | 1899 |
| Dumbbell Set 20kg | IronCore | 2799 |
| Vitamin C Serum 30ml | GlowLab | 649 |
| Herbal Shampoo 650ml | NatureRoot | 499 |
| Matte Lipstick Set (6) | Velvette | 799 |
| Basmati Rice 5kg | FarmPure | 749 |
| Cold-Pressed Oil 1L | FarmPure | 329 |
| Assorted Dry Fruits 1kg | NULL | 1099 |
| Building Blocks 250pc | NULL | 1499 |
| Strategy Board Game | NULL | 1199 |
| RC Stunt Car | NULL | 1999 |
| USB-C Fast Charger 65W | Volt | 1499 |
| Whey Protein 1kg | NULL | 2499 |
| Mystery Thriller Box Set | NULL | 1799 |
| Cotton Bedsheet King | HomeLuxe | 1099 |
| Smart Desk Lamp | Lumio | 1799 |
Run query to see output