Class 12th Practical paper-1
QUESTION
1. Write a program to generate a series of marks of 10 students. Give grace marks up to 3 marks of those who are having marks between 30 to 33 marks and print the new list of the marks.
2. Consider the following data for :
1. Create a dataframe using lists.
2. Display books for class XII.
3. Display the books whose price is more than 250.
4.Plot these data on line chart.
Consider the following table and write answers for given questions below:
Write SQL statements for the following based on table Garments:
Create above table in MySQL.
Insert records.
To display the detail of class XII students in descending order of their marks.
Display all the details of students in ascending order of name.
Find the maximum marks of the student for each class.
Count the students class wise is display only those number who is more than 2.
Display unique cities from the table.