Sogeti interview question

(On whiteboard) Write a SQL query to extract this specified information. Write code to swap two values without using a temp variables. Write code to reverse a string.