MySQL case语句练习-查询各国家用户各节点的连接成功次数及人数

查询各国家用户各节点的连接成功次数及人数

SELECT
	DISTINCT`host`,
	country,
	DATE_FORMAT(add_time,"%Y-%m-%d") as add_date,
	count(*) AS total_cishu,
	count( CASE WHEN error_code = 0 THEN uid END ) AS success_cishu,
	count( DISTINCT android_id ) AS total_person,
	count( DISTINCT CASE WHEN error_code = 0 THEN uid END ) AS success_person
FROM
	connect_report
WHERE
	add_time >= "2022-01-09 00:00:00" 
	AND add_time < "2022-01-16 00:00:00" 
	AND `host`<>""
GROUP BY
	`host`,country,add_date 
ORDER BY
	`host`,country,add_date ,total_cishu DESC;-- 活跃用户数据