Let’s tack some functionality on now and try to answer some queries:
- Who has been employed the longest?
- Who has been employed the shortest?
- Which people do not have email addresses listed?
- How many entries in the people table?
- Who is vested in the insurance plan (assume 20 years)?
- Was anyone hired today?
- Does anyone have a work anniversary today? If so, how long?
Answers here
Back to Class 3 Contents