Question of the Day

Creating a JSON Document II

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

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960

If I run this code, what document(s) is/are returned?

SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams n;

See possible answers