1. Worksheets

The purpose of this weeks worksheet is to provide additional SQL practice. Please attempt the worksheet without using provided answers. 

2. Questions and Completion

To receive credit for completing the worksheet, you must say ‘Done’ on the worksheet folder.

If you have questions as you go through this worksheet, please feel free to email the instructor.

3. Prerequisites: Oracle SQL Developer

If you have not done so already, download Oracle SQL Developer for your specific OS.

Now connect to the database using the instructions posted on D2L.

Test your connection. If successful, you are good to start.

4. Basic SQL-Single Table Practice.

1. List courseids offered in Spring but not in Fall of 2013.
2. List courseid in which there is no student enrolled.
3. List department and number of courses offered by each department.

5. Basic SQL-Join Practice

1. List students that are not presidents of any group.
2. Select all students whether presidents or not.
3. List all students who are members of HerCTI.

6. Basic SQL-Mixed Practice

1. List members of `HerCTI` that are not enrolled in courses.
2. Find the course with the highest course number
3. List courses ( even if nobody is enrolled) and their total enrollment by quarter.

Answers are available here