write all queries

Student(snum: integer, sname: string, major: string, level: string, age: integer Class(name: string, meets at: time, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty uid: integer. fnarne: string, deptid: integer) 2. Use the csv files from zip and insert given data into the database. 3. Write and execute all these queries on your database. 1. 2. 3. 4. Find the 2nd topper for class Operating System Design'. If there are two students with 5. Complete all queries from Exercise 5.1 Find name of Students who have enrolled in some classes, but have not yet received any grades for any of those classes. For each class, print the name of the class and name of student who topped the class. If 2 students have the same score, select the one who is younger the same score, select the one whose name is lexicographically smallest Query to check if 2 students have same name. Rank each student for the class Operating System Design'. For example, one who has scored highest will have rank 1, second highest will have rank 2 and so on. If 2 students have scored the same, they will have the same rank. 6. 7. Find classnames with no prerequisites. 8. Find all prerequisite for class 'Operating System Design' and 'Multivariate Analysis'. 9. Find all class names with at least 2 prerequisite. 10. Find youngest student by each department and major if their average grade score is more than 80 and order them by their name. 11. Add 5 to the score of every student who has grades for database systems, but ensure no one's score goes beyond 100