Write SQL commands for the following on the basis of given table relation Teacher (a) To show all information about the teacher

Q. Write SQL commands for the following on the basis of given table relation Teacher:

(a) To show all information about the teacher of history department .

(b) To list the names of female teachers who are in Hindi department .

(c) To list names of all teachers with their date of joining in ascending order.

Answer =

(a)
Select * from Teacher
Where department = ‘History’ ;

(b)
Select name from Teacher
Where sex = ‘F’ and department =  ‘Hindi’ ;

(c)
Select name, dateofjoin from Teacher
Order by dateofjoin ;