What is the size in kilobytes of the track with Id number 3407?

6. You are working with a database table that contains data about music. The table includes columns for track_id, track_name (name of the music track), composer, and bytes (digital storage size of the music track). You are only interested in data about the classical musician Johann Sebastian Bach. You want to know the size of each Bach track in kilobytes. You decide to divide bytes by 1000 to get the size in kilobytes, and use the AS command to store the result in a new column called kilobytes.

Add a statement to your SQL query that calculates the size in kilobytes for each track and stores it in a new column as kilobytes.

NOTE: The three dots (…) indicate where to add the statement.

SELECT
track_id,
track_name,
composer,
bytes,
. . .
FROM
track
WHERE
composer = "Johann Sebastian Bach"

5064

4744

2315

3192

Correct
You add the statement bytes / 1000 AS kilobytes to calculate the size in kilobytes for each track and store it in a new column as kilobytes. The complete query is SELECT track_id, track_name, composer, bytes, bytes / 1000 AS kilobytes FROM track WHERE composer = “Johann Sebastian Bach”. The AS command gives a temporary name to the new column.

The size of the track with Id number 3407 is 3192 kilobytes.

Related Questions & Answers: