Statistics on the number of men and women in a franchise store under Oracle database _oracle

WEB_THBC is the presentation layer, which is the page (. aspx)
BLL_THBC for the business logic layer
DAL_THBC for the database interaction layer (executing SQL statements to the database)
MODEL_THBC for entity classes
DBHelper for database connection classes

Statistics of the number of men and women in a franchise store

Copy Code code as follows:

Select Dua. Uarters_id,dua. Uarters_name
, sum (case when sex = ' 1 ' then 1 else 0-end) as Mans
, sum (case when sex = ' 0 ' then 1 else 0-end) as Woman
FROM dbo. Dcad_user as Du
Left Join
Dbo. Dcad_uarters as Dua
On Du. uarters_id = Dua. uarters_id
Group by Dua. Uarters_id,dua. Uarters_name

Author Ershouyage