With Grouped AS ( SELECT td.hobbies_1, td.hobbies_2, COUNT(*) AS count FROM _temp_data td GROUP BY GROUPING SETS ( (td.hobbies_1), (td.hobbies_2) ) ) SELECT jsonb ...

For a given two-dimensional integer array/list of size (N x M), you need to find out which row or column has the largest sum(sum of all the elements in a row/column) amongst all the rows and columns.

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want. It’s not unusual ...