Description

Write SQL queries for the following considering the tables created in the Sheet 1.

Assignment 4:

• Retrieve the name of the students whose name starts with ‘S’ and contains ‘r’ as the second last character.
• Retrieve the name of the youngest student(s) from the ‘CST’ department along with the total marks obtained by him (them). • Find the age of all the students.

Assignment 5:

• Retrieve the name of the student(s) who obtained second highest marks in ‘DBMS’.
• Find out the differences between highest and lowest marks obtained in each subject.
• Assuming the existance of several interdepartmental courses, retrieve the name of the student(s) who is(are) studing under at least one faculty from each department.
• Assuming the existance of several interdepartmental courses, retrieve the name of the student(s) who is(are) studing under the faculties only from his(their) own department.

Assignment 6:

• Display the highest parent incomes, in descending order, for each department excluding ‘ARCH’ such that only those highest parent incomes will appear that are below 12,000.
• Retrieve the fifth highest parent income for hostel number 5.
• Find the roll number of the students from each department who obtained highest total marks in their own department.