No installs, no setup. Watch a video, read the notes, run it against a real database, prove it with problems.
Schema
1SELECT2 country,3 COUNT(*) AS customers4FROM customers5WHERE is_active = TRUE6GROUP BY country7ORDER BY customers DESC;Output
| country | customers |
|---|---|
| India | 42 |
| USA | 37 |
| UK | 21 |
The invoice screen shows the tax separately. For every product, show product_name, price,
the 18% GST on that price under the heading GST Amount, and the price including GST
under the heading Price With GST. The headings must match exactly, including the spaces and
capital letters.
Don't round the calculated columns. End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
The invoice screen shows the tax separately. For every product, show product_name, price,
the 18% GST on that price under the heading GST Amount, and the price including GST
under the heading Price With GST. The headings must match exactly, including the spaces and
capital letters.
Don't round the calculated columns. End your query with ORDER BY product_id.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| product_name | price | GST Amount | Price With GST |
|---|---|---|---|
| Nova X5 Smartphone | 24999.00 | 4499.8200 | 29498.8200 |
| VoltBook Air 14 Laptop | 68990.00 | 12418.2000 | 81408.2000 |
| BassBoom Headphones | 2999.00 | 539.8200 | 3538.8200 |
| PixelTab 11 Tablet | 32999.00 | 5939.8200 | 38938.8200 |
| The Alchemist | 350.00 | 63.0000 | 413.0000 |
| Atomic Habits | 899.00 | 161.8200 | 1060.8200 |
| UPSC Mains Guide 2026 | 1299.00 | 233.8200 | 1532.8200 |
| Midnight Mystery Novel | 499.00 | 89.8200 | 588.8200 |
| Classic White Sneakers | 1999.00 | 359.8200 | 2358.8200 |
| Denim Jacket | 2499.00 | 449.8200 | 2948.8200 |
| Cotton Kurta - Navy | 1299.00 | 233.8200 | 1532.8200 |
| Steel Pressure Cooker 5L | 2199.00 | 395.8200 | 2594.8200 |
| Ceramic Dinner Set (18pc) | 3499.00 | 629.8200 | 4128.8200 |
| Air Fryer 4.5L | 8999.00 | 1619.8200 | 10618.8200 |
| Yoga Mat Pro 6mm | 999.00 | 179.8200 | 1178.8200 |
| Cricket Bat - Kashmir | 1899.00 | 341.8200 | 2240.8200 |
| Dumbbell Set 20kg | 2799.00 | 503.8200 | 3302.8200 |
| Vitamin C Serum 30ml | 649.00 | 116.8200 | 765.8200 |
| Herbal Shampoo 650ml | 499.00 | 89.8200 | 588.8200 |
| Matte Lipstick Set (6) | 799.00 | 143.8200 | 942.8200 |
| Basmati Rice 5kg | 749.00 | 134.8200 | 883.8200 |
| Cold-Pressed Oil 1L | 329.00 | 59.2200 | 388.2200 |
| Assorted Dry Fruits 1kg | 1099.00 | 197.8200 | 1296.8200 |
| Building Blocks 250pc | 1499.00 | 269.8200 | 1768.8200 |
| Strategy Board Game | 1199.00 | 215.8200 | 1414.8200 |
| RC Stunt Car | 1999.00 | 359.8200 | 2358.8200 |
| USB-C Fast Charger 65W | 1499.00 | 269.8200 | 1768.8200 |
| Whey Protein 1kg | 2499.00 | 449.8200 | 2948.8200 |
| Mystery Thriller Box Set | 1799.00 | 323.8200 | 2122.8200 |
| Cotton Bedsheet King | 1099.00 | 197.8200 | 1296.8200 |
| Smart Desk Lamp | 1799.00 | 323.8200 | 2122.8200 |
Run query to see output