Question 6 you are working with a database table that contains data about music. The table includes columns for track_id, track_name, composer, and album_id. You are only interested in data about the classical musician johann sebastian bach. You want to create new album ids. You decide to multiply the current album ids by 10 to create new album ids, and use the as command to store them in a new column called new_album_id. 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.

Respuesta :

Using the knowledge in computational language in SQL it is possible to write a code that working with a database table that contains data about music. The table includes columns for track_id, track_name, composer, and album_id.

Writting the code:

CREATE TABLE track

(

);

-- insert some rows in track table

INSERT INTO track (track_name, composer, album_id)

VALUES ('Ave Maria', 'Johann Sebastian Bach', 15),

      ('Salome', 'Richard Strauss', 18),

      ('Variations for piano', 'Anton Webern', 7),

      ('Concerto for two violins', 'Johann Sebastian Bach', 4);

See more about SQL at brainly.com/question/13068613

#SPJ1

Ver imagen lhmarianateixeira