<SYSTEM_TASK:>
Given the following text description, write Python code to implement the functionality described below step by step
<END_TASK>
<USER_TASK:>
Description:
 Title
Step1:  Create Table
Step2:  View Table
Step3:  Create New Empty Table
Step4:  Copy Contents Of First Table Into Empty Table
Step5:  View Previously Empty Table
<ASSISTANT_TASK:>
Python Code:
# Ignore
%load_ext sql
%sql sqlite://
%config SqlMagic.feedback = False
Explanation: Title: Copy Data From One Table To Another
Slug: copy_data_between_tables
Summary: Copy Data From One Table To Another in SQL.  
Date: 2016-05-01 12:00
Category: SQL
Tags: Basics
Authors: Chris Albon  
Note: This tutorial was written using Catherine Devlin's SQL in Jupyter Notebooks library. If you have not using a Jupyter Notebook, you can ignore the two lines of code below and any line containing %%sql. Furthermore, this tutorial uses SQLite's flavor of SQL, your version might have some differences in syntax.
For more, check out Learning SQL by Alan Beaulieu.
End of explanation
%%sql
-- Create a table of criminals_1
CREATE TABLE criminals_1 (pid, name, age, sex, city, minor);
INSERT INTO criminals_1 VALUES (412, 'James Smith', 15, 'M', 'Santa Rosa', 1);
INSERT INTO criminals_1 VALUES (234, 'Bill James', 22, 'M', 'Santa Rosa', 0);
INSERT INTO criminals_1 VALUES (632, 'Stacy Miller', 23, 'F', 'Santa Rosa', 0);
INSERT INTO criminals_1 VALUES (621, 'Betty Bob', NULL, 'F', 'Petaluma', 1);
INSERT INTO criminals_1 VALUES (162, 'Jaden Ado', 49, 'M', NULL, 0);
INSERT INTO criminals_1 VALUES (901, 'Gordon Ado', 32, 'F', 'Santa Rosa', 0);
INSERT INTO criminals_1 VALUES (512, 'Bill Byson', 21, 'M', 'Santa Rosa', 0);
INSERT INTO criminals_1 VALUES (411, 'Bob Iton', NULL, 'M', 'San Francisco', 0);
Explanation: Create Table
End of explanation
%%sql
-- Select all
SELECT *
-- From the table 'criminals_1'
FROM criminals_1
Explanation: View Table
End of explanation
%%sql
-- Create a table called criminals_2
CREATE TABLE criminals_2 (pid, name, age, sex, city, minor);
Explanation: Create New Empty Table
End of explanation
%%sql
-- Insert into the empty table
INSERT INTO criminals_2
-- Everything
SELECT * 
-- From the first table
FROM criminals_1;
Explanation: Copy Contents Of First Table Into Empty Table
End of explanation
%%sql
-- Select everything
SELECT *
-- From the previously empty table
FROM criminals_2
Explanation: View Previously Empty Table
End of explanation
<END_TASK>