Class XII CBSE Computer Science – Practical Practice Sets
Class XII CBSE Computer Science – Practical Practice Sets PRACTICE SET – 1 Part A – SQL Consider the table STUDENT : RollNo Name Class Stream Marks City 101 Amit XII Science 88 Pune 102 Riya XII Commerce 76 Mumbai 103 Karan XII Science 92 Pune 104 Neha XII Commerce 81 Delhi 105 Rahul XII Science 69 Mumbai Questions: Display all records from the table. Display the names and marks of students who scored more than 80. Display students belonging to Science stream. Display the names of students from Pune. Display students in descending order of marks. Find the maximum marks. Find the average marks. Count the number of students in each stream using GROUP BY . Display the highest marks obtained in each stream. Display students whose names start with R . Part B – Pandas Create the following DataFrame: import pandas as pd data = { 'Name' :[ 'Amit' , 'Riya' , 'Karan' , 'Neha' , 'Rahul' ], 'Marks...