• option C doesn't work, it throws an error while executing in sql 2005.