Completed
Incomplete
Not Attended
Share
Velocity Motors, a leading automobile dealership, maintains a comprehensive
inventory database with details such as vehicle_id, model, type, price, and quantity. As the
festive sales campaign approaches, the inventory manager needs SQL queries to highlight
premium vehicles for targeted promotions, calculate the total inventory value to understand
overall stock worth, and sort vehicles by price to easily identify high-end models — enabling
data-driven decisions for inventory management and marketing strategy.
Question - 1Display all vehicles sorted by price in ascending order.
Question - 2Calculate the total value of all vehicles in inventory (price × quantity).
Code Editor
Table Name: vehicles
| vehicle_id | model | type | price | quantity |
|---|---|---|---|---|
| 1 | Thunderbolt | Car | 25000.00 | 5 |
| 2 | Falcon | Motorbike | 15000.00 | 10 |
| 3 | Comet | Car | 30000.00 | 3 |
| 4 | Cyclone | Scooter | 5000.00 | 15 |
| 5 | Meteor | Car | 40000.00 | 2 |
>>> Submit Your Query to validate