Question

Q3. Consider the database for a college. Write the query for the following.

Insert at least 5 tuples into each table.

a. List the details of students in the ascending order of date of birth

b. Display the details of students from computer department

c. List the faculties in the descending order of salary

d. Display the total number of students in each department

e. Display the total number of faculties in each department with salary greater than 25000​

Answer 1

Answer:

College : I don't know the answer sorry