aoxu · November 9, 2018 08:04
diff --git a/sample.sql b/sample.sql
 SELECT
    user_id,
    max(event_params.value.int_value)  /* 只要已解锁的最大矿层数 */
 FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
 WHERE
  event_name = 'activate_manto'
  AND event_params.key = 'manto_id'
  AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181109'
 GROUP BY user_id /* 按用户id去重，每个id只保留最大矿层进度数 */
	SELECT
	user_id,
	max(event_params.value.int_value) /* 只要已解锁的最大矿层数 */
	FROM
	`analytics_168921341.events_*` AS T,
	T.event_params
	WHERE
	event_name = 'activate_manto'
	AND event_params.key = 'manto_id'
	AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181109'
	GROUP BY user_id /* 按用户id去重，每个id只保留最大矿层进度数 */
No results found