I am bad at XML, actually very bad. Have to execute each code in SSMS and then see the difference.

But still, what acually is different in C except that you see alias customersa and customersb, where as results are same and what is common between A, B and D queries ?

May be a person with good XML knowledge can explain.