Insert
This exercise consists of two parts: In the first, you'll create a new table very similar to the one you created in the previous interactive exercise. After that, you'll insert some data and retrieve it.
You'll continue working with the Chinook database here.
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create the table
CREATE TABLE tracks(
-- Create track column
___ ___(200),
-- Create album column
___ ___(160),
-- Create track_length_mins column
___ ___
);
-- Select all columns from the new table
SELECT
*
FROM
___;