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)