HOMEWORK

WARNING: you are not allowed to use information in your SQL code that was not given in the problem. A good example is using someone’s SSN when only their name is given to you in the problem. Every time this instruction is violated, even when the program returns the right results, you will lose 50% of the points. In the real world it is unrealistic to search through millions of records to find someone’s SSN. In some instances this information may be protected and off limits to you.

2) Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'employee'.

4) Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '.'.

5) Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'dependent'.

7) Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'JOIN'.

9) Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'JOIN'.