Exercise 4-11

Now You Try It

The corporate planning group wants to know what projects have been completed in less time than originally estimated.

Use the PROJECT table to identify the columns and display project ID as well as the number of hours saved.

The result looks like this:

PROJ_ID (EXPR) ------- ------ C203 58.50 1 row processed

If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax.