Answer to Question #306640 in Databases | SQL | Oracle | MS Access for Chetan mirje

Question

Q. Find topper of the each branch for both subjects individually and print:

1. Name of the faculty who taught that subject.

2. Name of the branch

3. Subject Name

4. Marks

5. Name of student

Q. Print name of the teacher who taught to most number of students for both subjects individually.

(Example Tejas G. taught maths to 2 students in following example database)

Q. Find branch wise average marks scored by students for both subjects.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order