Using the SQL Fiddle site

1. Write a select statement for all data contained within the employees table.

2. Write a select statement identifying all employee IDs associated with dept ID 2.

3. Write a select statement identifying the maximum salary grouped by deptid.

4. Write a select statement identifying all employee names whose title contains engineer.

5. Describe the difference between an inner and outer join.

6. Write a select statement identifying all employees and their dependents.

You may submit your responses with the query text (the actual SELECT statement) and screenshots of the output.