Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'name'.
If you are trying to get us to convert these to SQL queries for you, (and I suspect you are from this and your other question) then you have to remember two things:
1) Ask us what you actually mean. If you ask us "what does this do?" then we will answer "This does such-and-such". If you need help designing a quesry, then ask for help desiogning a query, but show us what you have tried.
2) We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.