Question

Consider the above tables and execute the following queries: [25 Marks]
1. List the college wise staff.
2. Display the details of Teachers who are working in Dr. D Y Patil College and their
specialization is "Computer".
3. Display the designation of teacher whose name is "Mr Patil" and he is working in
DPU college.
4. Display teacher wise salary.
5. Update an address of college to "Sant TukaramNagar" whose name is "MD College".

Answer 1

Answer:

1 List the college wise staff