<SYSTEM_TASK:>
Given the following text description, write Python code to implement the functionality described below step by step
<END_TASK>
<USER_TASK:>
Description:
 SQL practice session
To start off, re-write the code to extract the 5GB file to a database. You can look at my code if you get stuck, but dont copy paste. Look at the code, but type  it in yourself.
Make sure you delete the old database file, or rename it
I recommend you open a new Jupyter sheet to run your code
Click on File->New Notebook -> Python3
Next
Step1:  It returned empty because there is no zoidberg in our list.
Add it below.
Name
Step2:  Next
Step3:  Next
Step4:  There is a problem with the above
<ASSISTANT_TASK:>
Python Code:
# import sqlite3 here
#open connection to database
# 1st challenge: Write a sql query to search for the name: zoidberg
# Note: It will return 0
Explanation: SQL practice session
To start off, re-write the code to extract the 5GB file to a database. You can look at my code if you get stuck, but dont copy paste. Look at the code, but type  it in yourself.
Make sure you delete the old database file, or rename it
I recommend you open a new Jupyter sheet to run your code
Click on File->New Notebook -> Python3
Next: Some practice of sql queries
End of explanation
# Add the zoidberg data to the database below. remeber to commit()
# Search for zoidberg again. This time, you should get the results below:
Explanation: It returned empty because there is no zoidberg in our list.
Add it below.
Name: Zoidberg
Legal name: Planet Express
City: New New York
State: New New York
End of explanation
# Count number of practices in New York vs Texas
# 1st, get number in New York. You should get the values below
print("Number in NY: ", len(result))
# Now get Texas: 
print("Number in TX: ", len(result))
Explanation: Next: Compare the number of practices in New york (NY) vs Texas (Tx)
End of explanation
# Find number of Johns. Remember, this uses the % symbol
Explanation: Next: Find the number of people with John in their name
End of explanation
print(len(result))
#This time, printing the 1st 6 results as well, to check.
print(result[:6])
# Now find all Johns in the state 'AL'
print(len(result))
print(result[:6])
# Finally, Johns in AL and city of Mobile.
print(len(result))
print(result[:6])
#Always close the database!
conn.close()
Explanation: There is a problem with the above: It will include names like Johnathan.
What if we only want people with the name John?
Hint: In the search query, use 'john %'. Notice the space before %
Try that below:
End of explanation
<END_TASK>