How Do You Use Data from Certain Columns of an Existing

Multiple Choice

How do you use data from certain columns of an existing table to populate a new table with a matching structure?

A) Place a SELECT command within an INSERT command.
B) Execute a CREATE TABLE command with an INSERT clause.
C) Copy the existing table and delete the unwanted columns.
D) Add an INSERT clause after the WHERE clause in a SELECT command.