<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 Data
Step2:  View Table
Step3:  Update One Row
Step4:  Update Multiple Rows Using A Conditional
Step5:  View Table Again
<ASSISTANT_TASK:>
Python Code:
# Ignore
%load_ext sql
%sql sqlite://
%config SqlMagic.feedback = False
Explanation: Title: Edit Tables  
Slug: edit_tables  
Summary: Edit tables in SQL.  
Date: 2017-01-16 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
CREATE TABLE criminals (pid, name, age, sex, city, minor);
INSERT INTO criminals VALUES (412, 'James Smith', 15, 'M', 'Santa Rosa', 1);
INSERT INTO criminals VALUES (901, 'Gordon Ado', 32, 'F', 'San Francisco', 0);
INSERT INTO criminals VALUES (512, 'Bill Byson', 21, 'M', 'Petaluma', 0);
Explanation: Create Data
End of explanation
%%sql
--  Select all
SELECT *
-- From the criminals table
FROM criminals
Explanation: View Table
End of explanation
%%sql
-- Update the criminals table
UPDATE criminals
-- To say city: 'Palo Alto'
SET City='Palo Alto'
-- If the prisoner ID number is 412
WHERE pid=412;
Explanation: Update One Row
End of explanation
%%sql
-- Update the criminals table
UPDATE criminals
-- To say minor: 'No'
SET minor = 'No'
-- If age is greater than 12
WHERE age > 12;
Explanation: Update Multiple Rows Using A Conditional
End of explanation
%%sql
--  Select all
SELECT *
-- From the criminals table
FROM criminals
Explanation: View Table Again
End of explanation
<END_TASK>