Oracle Database Operations-count the number of men and women in a franchise store

Oracle Database Operations-statistics of the number of men and women in a franchise store Web_THBC for the presentation layer is the page (. aspx) BLL_THBC is the business logic layer DAL_THBC for the database interaction layer (Execute SQL statements to the database) Model_THBC is the entity class DbHelper for the database connection class statistics of the number of men and women in a franchise shop www.2cto.com select dua. UARTERS_ID, dua. UARTERS_NAME, sum (case when sex = '1' then 1 else 0 end) as Man, sum (case when sex = '0' then 1 else 0 end) as Womanfrom dbo. DCAD_USER as duleft join dbo. DCAD_UARTERS as dua on du. UARTERS_ID = dua. UARTERS_IDgroup by dua. UARTERS_ID, dua. UARTERS_NAME by ershouyage