1. Learn
    2. /
  2. Courses
    3. /
  3. Data Processing in Shell

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

undefined XP
    1
    2
    3

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