Question of the Day

Creating a JSON Document I

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers