Quary

[khalid.said]

1-select employee_id,last_name,salary

from employees

where salary !=12000

2-select employee_id,last_name,salary

from employees

where salary>7000 and department_id=60

3-select employee_id,last_name,salary

from employees

where salary>7000 or department_id=60

4-select employee_id,last_name,salary

from employees

where

   employee_id=101 or employee_id=102  or employee_id=103 or employee_id=107 or employee_id=110 or employee_id=112

or employee_id=120 or employee_id=113

5-select employee_id,last_name,salary

from employees

(where employee_id in(101,102,103,107,110,112,120,113