我有一个要过滤的任务: artist,song_count,most_popular_artist_song,most_acoustic_artist_song,most_energised_artist_song现在是我的代码: SELECT artists AS artist, count(name) AS songs, name , acousticness, energy , popularity ORDER BY popularity DESC, acousticness DESC, energy D
我有一个困难的时间软编码日期在蜂箱。我想做一个唯一的ID计数,我的数据出现在每周。例如:Count(distinct ID) Where filter1 = "Thing1" And filter2 =TO_DATE(timestamp_utc) between TO_DATE("2016-04-10") AND TO_DATE("2016-04-16")
但是我希望