Script works but Im not sure this is the best format
(SELECT CASE DoYouWishToP When 0 Then 'Yes, urgently'  When 1 Then 'Not peeing' END) 

is a Sub-select of the main select. It's simply a rule of SQL that it should be surrounded by parenthesis.
Ypercube is also right: if the columns, like "DoYouWishToP", are from the same table, you don't need the second and third SELECT. In that case it will work without the parenthesis. You normally only do a Sub-select using:

, (Select xxx **from** another_table where ...)