Word Count : 1125

---

The requirement to retrieve the details of vehicles whose total service cost exceeds ₹50,000 is a common database query problem in a DBMS and C++ Lab. It involves storing vehicle information, maintaining service records, calculating the total service cost for each vehicle, and displaying only those vehicles for which the accumulated service expenditure is greater than ₹50,000. This type of query demonstrates the practical use of relational tables, aggregate functions, grouping, joins, and the `HAVING` clause in SQL. A suitable database design can contain two related tables: `Vehicle` and `Service`. The `Vehicle` table stores basic information about each vehicle, while the `Service` table stores individual service transactions. For example, the `Vehicle` table may contain attributes such as `Vehicle_ID`, `Vehicle_No`, `Vehicle_Model`, `Owner_Name`, and `Vehicle_Type`. The `Service` table may contain `Service_ID`, `Vehicle_ID`, `Service_Date`, `Service_Type`, and `Service_Cost`. The `Vehicle_ID` acts as the primary key in the `Vehicle` table and as a foreign key in the `Service` table. An example structure can be represented as follows: ```sql CREATE TABLE Vehicle ( Vehicle_ID INT PRIMARY KEY, Vehicle_No VARCHAR(20), Vehicle_Model VARCHAR(50), Owner_Name VARCHAR(50), Vehicle_Type VARCHAR(30) ); CREATE TABLE Service ( Service_ID INT PRIMARY KEY, Vehicle_ID INT, Service_Date DATE, Service_Type VARCHAR(50), Service_Cost DECIMAL(10,2), FOREIGN KEY (Vehicle_ID) REFERENCES Vehicle(Vehicle_ID) ); ``` The service table can contain multiple records for the same vehicle because a vehicle may be serviced many times. For example, a vehicle with `Vehicle_ID = 101` might have service costs of ₹15,000, ₹20,000, and ₹25,000 on different dates. Its total service cost would therefore be ₹60,000. Since ₹60,000 is greater than ₹50,000, the vehicle must be included in the result. The SQL query to retrieve the required vehicle details is: ```sql SELECT v.Vehicle_ID, v.Vehicle_No, v.Vehicle_Model, v.Owner_Name, v.Vehicle_Type, _____ ___ _________ ___ _____.
_______ _________ ____ _________ _______ ________ __________ ___ _________.
_____ _________ _______ ___ _________ _____ ____ _______ ____ __________.
_____ ________ ______ ___ ______ __________ _________ ____ ________ __________.
____ _____ _________ ______ ________ ___ _________ _____ ____.
______ ____ ____ ___ __________.
_____ ________ _______ ___ ______ ____ ______ _____ ____ _______ ____.
__________ ________ ________ __________ ________ ___ ___.
_____ _____ ___ ______ __________ _________ _________ _______ _________ ________.
_____ ______ _______ ________ ___ ______ __________ ____ _________.
______ __________ ________ ________ ___ _________ ______ _____ ____ ____ ___ _____.
__________ _________ ________ ______ ______ ___ ____ ____ ___ ____ _________ _____.
_______ ___ ______ ____ ____ _________ ______ _________ ______ _______.
_____ _____ _______ ____ ________ ____.
______ _____ ______ ____ ___ ________ ________ ________ ______ _______.
__________ ___ __________ ___ ____ _________ _________ __________ _____ _________ ______.
_______ ________ _______ _________ ____ _________ ___.
_____ __________ ______ ______ ____ ___ ________ _______.
________ ______ _____ ____ ____ ____ _____ __________ __________.
_______ ______ _______ __________ _______ ____ _______ ___ ____.
___ __________ _________ _____ ___ ____ __________ ________ _________ ______.
_______ ________ ___ ______ _____ ____.
_________ _______ ________ _____ ____ _______ _________.
_________ _______ ______ ______ _____ ________ _______ _____ ___ __________.
__________ _____ _________ ______ __________ _________ ______ ___.
____ _______ __________ ______ __________ ________ __________.
_______ _____ _____ ______ _______.
______ _________ ______ _____ _____ ___.
___ ________ _____ ___ _____.
_______ __________ _______ _______ ___ _____ ___.
___ _________ ____ ______ ________ _________ _________ ________ ___ _______ _________.
_______ _________ ______ __________ _________ ____ _________ _______ ___ ______.
_______ _______ _______ _______ ______ ________ ______ _____ ________ ____.
________ ___ __________ ____ ____ _________ _______ ______ __________.
____ __________ ____ ________ _______ _____ ______ _____ __________.
_____ ____ _____ ______ _____ ____ _____.
________ ________ ____ _____ ___ __________.
_____ _____ __________ _________ __________ ___ _______.
_______ _________ ________ _________ ________ _____ _____ ____ __________ __________.
____ ________ _____ ___ ____ _________ ____ __________.
_____ __________ ____ _____ ____ ___ ______ ____ ___ _________ ___ ____.
________ ______ _____ _______ _________ ____ ________.
______ _________ ____ _______ ________ ______.
____ ____ _______ ____ ______ ________ ______ __________.
___ ____ _________ _________ _______ __________ ____ _____ _________ __________ _________ ____.
__________ _____ __________ ________ _______ _________ ____ ________ _____ ___.
________ ________ ______ ______ ______ ____ ____ ________ ____.
_________ ________ __________ ___ ________ _______ ___ ________ ________ ______ _______ ____.
_____ __________ _______ ______ __________ ____ ________ __________.
________ __________ ______ ______ __________ _________ _____ ____ __________ __________.
_____ _______ _____ ________ ______ __________ _______ ___ __________ _________ ____.
__________ _______ ______ _______ ___ ______ _____.
____ ______ _____ ______ __________ ___ ________ __________ ________ _____.
__________ ________ ___ ___ _________ __________ _______ ________ ______ ______ __________ ____.
_____ ______ _____ _____ _______ _______.
_________ ___ ________ _________ _____ ______.
__________ _____ __________ ________ _______ __________ ____ ______ ____ ______ _________ ______.
______ _____ ______ ___ _________ ___ ______ ________ ____ _______ ____ _____.
_______ ______ ____ ___ ____.
____ ______ _______ ______ ______ ___.
____ _________ ______ _______ __________ _________ ___ __________ _____.
_____ ____ ____ __________ _____ _________.
___ __________ ________ ____ __________ _________ _________ _____ ___.
_______ ____ ____ _________ ___ __________ ____ _______ _______.
_________ _______ ______ ______ __________ ________ _____ ______ ___.
____ _______ ________ ___ _____ ____ ________ ______.
________ ________ _______ ________ _________ _____.
___ __________ _____ ____ ____ ____ __________.
__________ ________ _____ ____ _______ _______ __________ ______ _________ ________ _____ _____.
_____ _________ ___ _______ ________ ____ __________ _________ _______ ________ _______.
_________ ______ _____ ____ _________ _____ _________ _______ ____ ___ _______.
__________ __________ ______ ___ ______ _________.
__________ ___ _______ __________ __________ ______ __________ _____ _____ __________ ____.
___ ______ ____ _______ _____ _______ _______ ________ _________ ________ ________ _________.
________ ____ __________ ___ __________ _______ _________ ________ _____.
___ ____ __________ ___ ________.
___ _______ ________ _____ _______ _________ __________.
_____ ______ ___ ____ ___ _____ ___ __________ ________ _____.
__________ ____ ____ ___ ___.
_____ _________ _________ __________ _____ _______ ____ _________ ____ __________.
____ __________ __________ ____ _____.
_______ ___ _____ ________ ________ _________ ____ _____ _______ _______.
____ _______ ________ ___ ________ ___ ____ _______ __________ _____ _____.
_____ _________ _________ _________ _________ __________.
_______ ____ ____ ______ ________ ____ ___ _____ __________ ________.
______ _________ __________ ________ _________ _____ _______ ______ _______.
______ ______ ______ ______ _______ ________.
__________ _________ _________ _______ ______ ________ _____ ______ __________ _________.
______ ___ ____ ___ ______ __________ ______ _______ ______ _______ ________.
___ ____ ________ ___ ___ ____ ______.
______ ____ _________ ______ _______ _____.
_________ ___ _______ ____ __________ _______.
_______ ________ ____ __________ _____ ________ _________ __________ ____ __________ _____.
_________ ________ _________ __________ _____.
__________ ___ ____ ___ ____ ______ _________ ________ ________ _________.
____ __________ __________ _______ _________.
____ ______ ____ ________ ____ _________ _________.
_______ ______ _________ __________ ____.
________ _________ __________ _______ ______ _______ ______ ____ _________.
____ __________ _________ __________ _______.
Get Full Answer on WhatsApp