Google BigQuery选择每天的max

Question

我有一个问题与我的BigQuery选择，我需要得到列(学生)每天的最大值。

SELECT EXTRACT(DATE FROM timestamp) as date, ARRAY_LENGTH(student_ids) as students from analytics.daily_active_students_count order by timestamp desc

<表类>行日期学生tbody><<tr>12022-05-167222022-05-163332022-05-161242022-05-151052022-05-158462022-05-15872022-05-149282022-05-1410592022-05-1412

问题是我的后端使用不同的时区。我用转换时间戳解决了这个问题:

DATE(DATETIME(TIMESTAMP, "Europe/Zagreb")) as date