Add a statement to your SQL query that calculates a new album Id for each track and stores it in a new column as new_album_id.
NOTE: The three dots (…) indicate where to add the statement.
SELECT
track_id,
track_name,
composer,
album_id,
. . .
FROM
track
WHERE
composer = "Johann Sebastian Bach"
Correct
You add the statement album_id * 10 AS new_album_id to calculate a new album ID for each track and store it in a new column as new_album_id. The complete query is SELECT track_id, track_name, composer, album_id, album_id * 10 AS new_album_id FROM track WHERE composer = “Johann Sebastian Bach”. The AS command gives a temporary name to the new column.
The new Album Id for the track with Id number 3490 is 3350.
