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
   10   11   12   13   14   15   16   17   18   19   20