SQL statements

Develop SQL statements using the EMP and DEPT tables

1.)List all department names and dept numbers greater than 20

2.) List the salesman that have a monthly salary greater than $1300

3.) List all employee names whose names begin with W

4.) Find all employees who are not salesman

5.) List all employees and their jobs who have no commission

6.) What is the average salary for each job? (Hint: Use Group by)

7.) What is the average salary for each job by location? (Hint: Sort by location, then by job)

8.) Find all the employees who have a salary of at least $2500 and are not managers

9.) In what City does Allen work? (Hint: its just one City)

10.) What are the names of the employees in Chicago that have a salary greater than $1000 but less than $1575? (Hint: Use Between)