AISSCE
PRACTICAL EXAM COMPUTER SCIENCE (083)
SESSION : 2025-26
SET-1
1. Consider LOANS table and perform following queries:
(i) Display the sum of all loan amounts whose interest rate is greater than 10.
(ii) Display the maximum interest from LOANS table.
(iii) Display the count of all loan holders whose name ends with ‘Sharma’.
(iv) Display the count of all loan holders whose interest rate is NULL.
Table : LOANS
Ans. (i) Select sum(Loan_Amount) from LOANS where Int_Rate>10;
(ii) Select max(Intresest) from LOANS;
(iii) Select count(Cust_Name) from LOANS;
(iv) Select count(Cust_Name) from LOANS where Int_Rate=NULL;
AISSCE
PRACTICAL EXAM COMPUTER SCIENCE (083)
SESSION : 2025-26
SET-2
1. Write SQL commands for the given FURNITURE table:
(i) To list the details of furniture whose price is more than 10000.
(ii) To list the item name and price of furniture whose discount is between 10 and 20.
(iii) To delete the records of all items where discount is 30.
(iv) To display item name, type and price of all items whose name starts with ‘D’.
Table : FURNITURE
Ans. (i) select * from FURNITURE where PRICE>10000;
(ii) select ITEM, PRICE from FURNITURE where DISCOUNT between 10 and 20;
(iii) delete from FURNITURE where DISCOUNT=30;
(iv) select ITEM, TYPE, PRICE from FURNITURE where ITEM like 'D%';
AISSCE
PRACTICAL EXAM COMPUTER SCIENCE (083)
SESSION : 2025-26
SET-3
1. Consider the given table and perform following queries:
(i) To display all the information of students where capacity is more than the no. of students in order
of Route no.
(ii) To show area covered for buses covering more than 20 km. but charges less than 80000.
(iii) To show route no., area covered and average cost per student for all routes where average cost
per student = charges/no. of students.
(iv) Add a new record as: (11,”Motibagh”,35,32,10,”Kisan Tours”,35000).
Table : SchoolBus
Ans. (i) select * from SchoolBus order by Rtno where Capacity>Noofstudents;
(ii) select Area_Covered from SchoolBus where Distance>20 and Charges<80000;
(iii) select Rtno, Distance, (Charges/Noofstudents) as Costperstudent from Schoolbus;
(iv) insert into SchoolBus values (11,”Motibagh”,35,32,10,”Kisan Tours”,35000);
AISSCE
PRACTICAL EXAM COMPUTER SCIENCE (083)
SESSION : 2025-26
SET-4
2. Consider the following two tables and perform the queries:
(i) Display the department and count of teachers department-wise.
(ii) Display the newest and oldest joining dates of teachers.
(iii) Display the total number of teachers working in Mathematics department.
(iv) Display the name of teacher, department and place of posting of all teachers who are posted in
Table1 : Teacher Table2 : Posting
Ans. (i) select Department, count(Name) from Teacher, Posting order by Department;
(ii) select max(Date_of_join), min(Date_of_join) from Teacher;
(iii) select count(NAME) from TEACHER where Department='Mathematics'
(iv) select Name, Department, Place from Teacher,Posting where Place='Delhi';