You are querying a database that contains data about music. Each album is given an ID number. You are only interested in data related to the album with ID number 6. The album IDs are listed in the album_id column.

You write the SQL query below. Add a WHERE clause that will return only data about the album with ID number 6.

SELECT 
*
FROM 
track

Correct
The clause WHERE album_id = 6 will return only data about the album with ID number 6. The complete query is SELECT * FROM track WHERE album_ID = 6. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include.

13 tracks are on the album with ID number 6.

Related Questions & Answers: