学习SQL 记录Spotify Wrapped世界神奇频率

今天学习了一个很有趣的问题，分享一下 

Spotify 利用音乐的各种属性来对歌和人分类。然后每年会给你生产一个报告。

Spotify Wrapped is a feature presenting Spotify users’ 100 most played songs from the past year. In 2021, Spotify Wrapped calculated an “Audio Aura” for each user, a “reading of [their] two most prominent moods as dictated by [their] top songs and artists of the year.” Suppose Spotify determines an audio aura by looking at the average energy, valence, and danceability of a person’s top 100 songs from the past year.

Speechiness ：说话指数

Speechiness detects the presence of spoken words in a track. The more exclusively speech-like the recording (e.g. talk show, audio book, poetry), the closer to 1.0 the attribute value. Values above 0.66 describe tracks that are probably made entirely of spoken words. （resource: github.io）

如果这个指数大于0.66 的话就说明这个歌可能一直都是在说话了。

Valence: Valence 愉快指数，valence 高的歌听了让人开心低了，让人难过。

神奇的发现，Drake 的歌居然能量是0.599 这个神奇的数字。不愧是Drake。