Duplicate columns postgres vs sql server

[Laoujin]

postgres only returns the first value (second one is "gone")
sql server returns an array of values

postgres is mentioned in the pptx

sql server displays NaN