SQL has the pivot function that can perform column to row conversion, but column names must be written out. Dynamically generating column names would be very complex. Here, we can only change the ...

First uses GROUPING SETS to group and count different columns simultaneously, and then uses jsonb_object_agg to convert each record set into JSON separately. The code is quite cumbersome; And the ...

To convert the rows to column in MySQL Sample query: select column1, count ( (case when (column2 = 'M') then 0 end)) AS `males`, count ( (case when (column2 = 'F') then 0 end)) AS `females`,count (0) ...