Create instructor table in sql by orcal

**create instructor table**

 create table instructors (Name varchar2(10),department varchar2(10),salary int);

insert into instructors values('anuj','physics',90000);

insert into instructors values('ram','mechnical',75000);

insert into instructors values('sahil','science',80000);

insert into instructors values('ankit','math',50000);

insert into instructors values('shruti','dames',60000);

**Where condition by select oprator**

select*from instructors

where department='physics';

**2nd*"

select*from instructors

where salary>80000;

**3rd**

select*from instructors

where salary>60000 and department='physics';

**4rth**

select name,department

from instructors

where department='mechnical';