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
   27   28   29   30   31   32   33   34   35   36   37