Create tables
Say you want to create a table to consolidate some useful track information into one table. This will consist of the track name, the artist, and the album the track came from. You also want to store the track length in a different format to how it is currently stored in the track table. How can you go about doing this? Using CREATE TABLE. Recall the example from the video:
CREATE TABLE test_table(
test_date DATE,
test_name VARCHAR(20),
test_int INT
)
Let's get started!
Questo esercizio fa parte del corso
Introduction to SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create the table
___ ___ ___ (
-- Create track column
___ ___(___),
-- Create artist column
___ ___(___),
-- Create album column
___ ___(___),
);