Page 32 - IPP-12-2025
P. 32
Table 1: STUDENTS
RegID Stu_Name Course
110076 Ananya Sharma Python
111098 Rahul Verma Artificial Intelligence
121908 Meena Rathi Web Designing
110078 Arjun Mehta Data Science
110065 Siya Gupta Python
Table 2: BATCH
Batch_No RegID Shift
B101 110078 Morning
B102 110076 Evening
B103 121908 Morning
B104 111098 Evening
B105 110065 Morning
Write appropriate SQL queries for the following:
(a) Display the details of the batch of the morning shift.
(b) Display the total number of students course-wise.
(c) Display Student Name, Course and Shift of the students whose names start with letter ‘A’.
SECTION D (2 x 4 = 8 Marks)
33. Aarav, a data scientist, is preparing a line chart to visualize monthly rainfall (in mm) for a city over the past
five months. The rainfall data (in mm) is as follows: [4]
Month Rainfall
Jan 80
Feb 70
Mar 60
Apr 50
May 30
Help Aarav complete the following Python code to generate the line chart:
Practice Paper P.5