Skip to content
January 24, 2026

Class 12th MYSQL solution

Class 12th MYSQL solution

SQL

Create Database

CREATE DATABASE TransportDB;
USE TransportDB;

Create table

CREATE TABLE Vehicle (
    VCODE VARCHAR(5) PRIMARY KEY,
    VEHICLETYPE VARCHAR(20),
    PERKM INT
);
  CREATE TABLE Travel (
    CNO INT,
    CNAME VARCHAR(30),
    TRAVELDATE DATE,
    KM INT,
    VCODE VARCHAR(5),
    NOP INT,
    FOREIGN KEY (VCODE) REFERENCES Vehicle(VCODE)
);

Insert Records

Vehicle Table

INSERT INTO Vehicle VALUES
('V01','VOLVO BUS',150),
('V02','AC DELUXE BUS',125),
('V03','ORDINARY BUS',80),
('V05','SUV',30),
('V04','CAR',18);

Travel Table

INSERT INTO Travel VALUES
(101,'K. Niwal','2015-12-13',200,'V01',32),
(103,'Fredrick Sym','2016-03-21',120,'V03',45),
(105,'Hitesh Jain','2016-04-23',450,'V02',42),
(102,'Ravi Anish','2016-01-13',80,'V02',40),
(107,'John Malina','2015-02-10',65,'V04',2),
(104,'Sahanubhuti','2016-01-28',90,'V05',4),
(106,'Ramesh Jaya','2016-04-06',100,'V01',25);

Delete customers who traveled using CAR

DELETE FROM Vehicle
WHERE VEHICLETYPE = 'CAR';

Increase PERKM of all buses by 10

UPDATE Vehicle
SET PERKM = PERKM + 10
WHERE VEHICLETYPE LIKE '%BUS%';

Display Customer Name, Vehicle Type, and Total Fare

Formula: Total Fare = KM × PERKM × NOP

 
SELECT T.CNAME, V.VEHICLETYPE,
       (T.KM * V.PERKM * T.NOP) AS TOTAL_FARE
FROM Travel T, Vehicle V
WHERE T.VCODE = V.VCODE;

Display VCODE and total passengers (>30), descending

SELECT VCODE, SUM(NOP) AS TOTAL_PASSENGERS
FROM Travel
GROUP BY VCODE
HAVING SUM(NOP) > 30
ORDER BY TOTAL_PASSENGERS DESC;

Blog Insights