• I tried the query on SQL SERVER 2005 and it ran fine with giving result as specified in choice (a).