Untitled

Create table TEACHER(Name varchar(20), Age int, Department varchar(20), Dateofjoin date, Salary numeric(6,2), Sex Varchar(10));

Select * from TEACHER where 
Department='computer';

SELECT NAME, SALARY FROM TEACHER WHERE
 SEX='MALE' AND DEPARTMENT='maths';

select NAME from TEACHER
ORDER BY DATEOFJOIN ;

SELECT NAME, SALARY, AGE FROM TEACHER
WHERE SEX='MALE';