| | |
|---|
| | | SELECT |
|---|
| | | COUNT(*) AS totalUser, |
|---|
| | | SUM(CASE WHEN tau.user_type = 2 THEN 1 ELSE 0 END) AS shopUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id < 4 THEN 1 ELSE 0 END) AS consumerUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id <![CDATA[<]]> 4 THEN 1 ELSE 0 END) AS consumerUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 1 THEN 1 ELSE 0 END) AS commonUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 2 THEN 1 ELSE 0 END) AS goldUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 3 THEN 1 ELSE 0 END) AS diamondUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id > 3 THEN 1 ELSE 0 END) AS entrepreneurUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id <![CDATA[>]]> 3 THEN 1 ELSE 0 END) AS entrepreneurUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 4 THEN 1 ELSE 0 END) AS proxyUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 5 THEN 1 ELSE 0 END) AS agentUser, |
|---|
| | | SUM(CASE WHEN tau.vip_id = 6 THEN 1 ELSE 0 END) AS totalAgentUser, |
|---|
