Page 15 - IPP-12-2025
P. 15
Ans. (a) SELECT MAX(Charges), MIN(Charges) FROM CAMP;
(b) SELECT RIGHT(Student_Name, 5) FROM STUDENT;
(c) SELECT UPPER(Doctor_Name) FROM DOCTORS;
(d) SELECT SUM(Marks) FROM SEMESTER;
(e) SELECT COUNT(Subject) FROM TEACHERS;
Or
(a) SELECT ROUND(198.456,2);
(b) SELECT MOD(123,5);
(c) SELECT LCASE('PathToLearningAndEnlightenment');
(d) SELECT LEFT(‘Information Protocol', 6);
(e) SELECT RTRIM(Employee_Designation) FROM EMPLOYEES;
M.12 Informatics Practices with Python–XII