Exercise

Applying SQL to a local CSV file

Sometimes the data manipulation we want to do is just easier to do with SQL. In this situation, we want to find the shortest duration song in Spotify_MusicAttributes.csv by applying the SQL below directly to the data file.

SELECT * FROM Spotify_MusicAttributes ORDER BY duration_ms LIMIT 1

Let's go through this step by step.

Instructions 1/3

XP

1
2
3

Complete the command to apply the SQL query to Spotify_MusicAttributes.csv.

Take Hint (-10 XP)