Mysql-查询首次连接成功的用户的连接时长（可能会受到权限影响）

SELECT AVG(timer) as 平均连接时长 FROM(
	SELECT
		t_connect.android_id,
		t_connect.event_id as 首次点击连接,
		t_connect.event_start as 首次点击连接时间,
		t_success.event_id as 首次连接成功,
		t_success.event_start as 首次连接成功时间,
		t_success.event_start - t_connect.event_start AS timer 
	FROM
		( SELECT * FROM event_log_4136_temp WHERE event_id = 1691 ) AS t_connect
		INNER JOIN ( SELECT * FROM event_log_4136_temp WHERE event_id = 1692 ) AS t_success ON t_connect.android_id = t_success.android_id 
	HAVING
		ABS( timer )< 30 
	ORDER BY
		t_connect.android_id,
		t_connect.event_start 
	) as t;