Question

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii):

(i) To display Courseld, Teacherld, Name of Teacher, Phone Number of Teachers living in Delhi.

(ii) To display TeacherlD, Names of Teachers, Subjects of all teachers with names of Teachers starting with'*'.

(iii) SELECT Courseld, Subject, Teacherld, Name, PhoneNumber FROM Faculty, Course WHERE Faculty. Teaherld=Course' Teacherld AND Fee> =5000;

Answer 1

(i) Select C. Coursedld, F. Teacherld, F. Name, F. PhoneNumber from faculty F, Course C where F. Courseld C courseld and F. state like 'Delhi'.

(ii) Select Teacher Id, Name, Subject from Faculty F, Course C where F. Courseld = C.Courseld and F. Name like '*%'.

(iii)

| Courseld | Subiect | Name | TeacherID | PhoneNumber |
| C103 | Physics | Savik Sharma | T101 | 997019564 |
| C105 | Adwance Computer Science | Simi Arora | T104 | 658777569 |