As mentioned earlier, after executing the above code,

Go to

DataBases -> SystemDataBases -> tempdb -> TestTable -> Columns .

You can see that column C1 is created with type bigint and C2 is created with type int based on the highest precedence in the select list.

I think this could be the practical example you are expecting.

Thanks

Gopi