How to use SQL statements to build such a table,

CodePudding user response:

According to date of gender division group good
The select tc reatedate, t.d epartment, t.s ex, count (t.p erson) from tablename t group by t.s ex, t.d epartment, tc reatedate