{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# SQLite\n", "\n", "![SQLite logo](https://upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/320px-SQLite370.svg.png)\n", "\n", "\n", "***\n", "\n", "**[sqlite3 Python documentation](https://docs.python.org/3.7/library/sqlite3.html)**\n", "\n", "*[https://docs.python.org/3.7/library/sqlite3.html](https://docs.python.org/3.7/library/sqlite3.html)*\n", "\n", "The sqlite3 Python package documentation page.\n", "\n", "\n", "***" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Databases" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "![MySQL client](https://upload.wikimedia.org/wikipedia/commons/d/dd/Mysql-screenshot.PNG)\n", "\n", "People use the term database to sometimes mean:\n", "\n", "- The data set itself.\n", "- A program that manages datasets.\n", "- The computer that runs the program." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### Purposes\n", "\n", "- Persistent storage.\n", "- Fast data storage and retrieval algorithms.\n", "- Dealing with multi-user conflicts." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### Types\n", "\n", "![Relational database table](https://upload.wikimedia.org/wikipedia/commons/thumb/f/f2/DVD_Rental_Query.png/554px-DVD_Rental_Query.png)\n", "\n", "- Relational databases where data are structured in tables.\n", "- NoSQL databases with no particular structure.\n", "- Relational versus all other types, because relational are historically the most common." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### Many tables\n", "\n", "![SQL join](https://i2.wp.com/ramkedem.com/wp-content/uploads/2015/08/sql_inner_join.png?w=600)\n", "\n", "- Excel is great for single table scenarios.\n", "- Gets a little clunky when you have two or more tables that are related." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### Connections\n", "\n", "\n", "- Database server/management system is a program running on some machine.\n", "- Access it by knowing the connection details, supplied by the database administrator.\n", "- Typcially need database type, IP address, port, username, password, database name.\n", "\n", "\n", "***\n", "\n", "```python\n", "\n", "import mysql.connector\n", "cnx = mysql.connector.connect(user='scott', password='password',\n", " host='127.0.0.1',\n", " database='employees')\n", "cnx.close()\n", "\n", "```\n", "\n", "***" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### SQLite\n", "\n", "- Simple database that runs in memory.\n", "- Not really a separate program/process/software - it's part of your program.\n", "- Uses the SQL language." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "### SQL\n", "\n", "- Structured Query Language.\n", "- Simple syntax.\n", "- State what you want, not how to get it.\n", "- CRUD: Create, Retrieve, Update, Delete.\n", "\n", "***\n", "\n", "```sql\n", " CREATE TABLE person(id AUTOINCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255));\n", " INSERT INTO person VALUES(\"Joe Bloggs\", \"Galway\");\n", " SELECT name FROM person;\n", " UPDATE person SET address=\"Sligo\" WHERE name=\"Joe Bloggs\";\n", " DELETE FROM person WHERE name=\"Joe Bloggs\";\n", " DROP TABLE person;\n", "```\n", "\n", "***" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Join in pandas" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAddress
ID
0Anna HenryCarlow
1Shelby BeckTipperary
2Marie CarrKerry
3Sarah HeathMonaghan
4Robert SnyderLeitrim
5Lucas RossCork
6David CoxLeitrim
7Jackson DeanLouth
8Elizabeth McfarlandDublin
9Timothy CummingsLimerick
\n", "
" ], "text/plain": [ " Name Address\n", "ID \n", "0 Anna Henry Carlow\n", "1 Shelby Beck Tipperary\n", "2 Marie Carr Kerry\n", "3 Sarah Heath Monaghan\n", "4 Robert Snyder Leitrim\n", "5 Lucas Ross Cork\n", "6 David Cox Leitrim\n", "7 Jackson Dean Louth\n", "8 Elizabeth Mcfarland Dublin\n", "9 Timothy Cummings Limerick" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "person = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/person.csv\", index_col=0)\n", "person.head(10)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
RegistrationOwnerId
ID
008-SO-110729
116-KE-1636897
208-LD-1687117
311-KY-1744222
416-LD-1754548
510-WH-354310
603-KE-814874
706-G-230244
808-LS-2177093
903-WX-4171753
\n", "
" ], "text/plain": [ " Registration OwnerId\n", "ID \n", "0 08-SO-11072 9\n", "1 16-KE-16368 97\n", "2 08-LD-16871 17\n", "3 11-KY-17442 22\n", "4 16-LD-17545 48\n", "5 10-WH-3543 10\n", "6 03-KE-8148 74\n", "7 06-G-23024 4\n", "8 08-LS-21770 93\n", "9 03-WX-41717 53" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "car = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/car.csv\", index_col=0)\n", "car.head(10)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
RegistrationName
ID
0CWCarlow
1CNCavan
2CEClare
3CCork
4DLDonegal
5DDublin
6GGalway
7KYKerry
8KEKildare
9KKKilkenny
\n", "
" ], "text/plain": [ " Registration Name\n", "ID \n", "0 CW Carlow\n", "1 CN Cavan\n", "2 CE Clare\n", "3 C Cork\n", "4 DL Donegal\n", "5 D Dublin\n", "6 G Galway\n", "7 KY Kerry\n", "8 KE Kildare\n", "9 KK Kilkenny" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "county = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/county.csv\", index_col=0)\n", "county.head(10)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
RegistrationName
008-SO-11072Timothy Cummings
116-KE-16368Dana Wade
208-LD-16871Valerie Stewart
311-KY-17442Gregory Vazquez
416-LD-17545Sara Lee
\n", "
" ], "text/plain": [ " Registration Name\n", "0 08-SO-11072 Timothy Cummings\n", "1 16-KE-16368 Dana Wade\n", "2 08-LD-16871 Valerie Stewart\n", "3 11-KY-17442 Gregory Vazquez\n", "4 16-LD-17545 Sara Lee" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Join the car and person data frames on two columns.\n", "pd.merge(car, person, left_on=\"OwnerId\", right_on=\"ID\", how=\"left\")[[\"Registration\", \"Name\"]].head()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Registration_xOwnerIdName_xAddressRegistration_yName_y
0SO9Timothy CummingsLimerickLLimerick
1KE97Dana WadeMayoMOMayo
3KY22Gregory VazquezSligoSOSligo
4LD48Sara LeeLaoisLSLaois
5WH10Jennifer ReevesOffalyOYOffaly
6KE74Leonard ChenGalwayGGalway
7G4Robert SnyderLeitrimLMLeitrim
8LS93Morgan MarshWestmeathWHWestmeath
9WX53Kayla Rodriguez DVMClareCEClare
10T63Robert AcevedoMeathMHMeath
\n", "
" ], "text/plain": [ " Registration_x OwnerId Name_x Address Registration_y \\\n", "0 SO 9 Timothy Cummings Limerick L \n", "1 KE 97 Dana Wade Mayo MO \n", "3 KY 22 Gregory Vazquez Sligo SO \n", "4 LD 48 Sara Lee Laois LS \n", "5 WH 10 Jennifer Reeves Offaly OY \n", "6 KE 74 Leonard Chen Galway G \n", "7 G 4 Robert Snyder Leitrim LM \n", "8 LS 93 Morgan Marsh Westmeath WH \n", "9 WX 53 Kayla Rodriguez DVM Clare CE \n", "10 T 63 Robert Acevedo Meath MH \n", "\n", " Name_y \n", "0 Limerick \n", "1 Mayo \n", "3 Sligo \n", "4 Laois \n", "5 Offaly \n", "6 Galway \n", "7 Leitrim \n", "8 Westmeath \n", "9 Clare \n", "10 Meath " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Find people with cars registered in counties other than where they live.\n", "tmp = pd.merge(car, person, left_on=\"OwnerId\", right_on=\"ID\", how=\"left\")\n", "tmp = pd.merge(tmp, county, left_on=\"Address\", right_on=\"Name\", how=\"left\")\n", "tmp['Registration_x'] = tmp['Registration_x'].apply(lambda x: x.split(\"-\")[1])\n", "tmp = tmp[tmp['Registration_x'] != tmp['Registration_y']]\n", "tmp.head(10)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## SQLite in Python" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "import sqlite3" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "conn = sqlite3.connect('data/example.db')" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "c = conn.cursor()" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "c.execute('CREATE TABLE person(name text, address text)')\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('person',)]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT name FROM sqlite_master\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "c.execute(\"INSERT INTO person VALUES ('Anna Henry', 'Carlow')\")\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Anna Henry', 'Carlow')]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT name, address FROM person\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "people = [('Shelby Beck', 'Tipperary'), ('Marie Carr', 'Kerry'), ('Sarah Heath', 'Monaghan')]" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Shelby Beck', 'Tipperary'),\n", " ('Marie Carr', 'Kerry'),\n", " ('Sarah Heath', 'Monaghan')]" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "people" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [], "source": [ "c.executemany(\"INSERT INTO person VALUES (?, ?)\", people)\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Anna Henry', 'Carlow'),\n", " ('Shelby Beck', 'Tipperary'),\n", " ('Marie Carr', 'Kerry'),\n", " ('Sarah Heath', 'Monaghan')]" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT name, address FROM person\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "c.execute(\"INSERT INTO person VALUES ('Anna Henry', 'Carlow')\")\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[(1, 'Anna Henry', 'Carlow'),\n", " (2, 'Shelby Beck', 'Tipperary'),\n", " (3, 'Marie Carr', 'Kerry'),\n", " (4, 'Sarah Heath', 'Monaghan'),\n", " (5, 'Anna Henry', 'Carlow')]" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT ROWID, name, address FROM person\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [], "source": [ "c.execute(\"DELETE FROM person WHERE ROWID=1\")\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[(2, 'Shelby Beck', 'Tipperary'),\n", " (3, 'Marie Carr', 'Kerry'),\n", " (4, 'Sarah Heath', 'Monaghan'),\n", " (5, 'Anna Henry', 'Carlow')]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT ROWID, name, address FROM person\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "c.execute(\"INSERT INTO person VALUES ('Robert Snyder', 'Leitrim')\")\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[(2, 'Shelby Beck', 'Tipperary'),\n", " (3, 'Marie Carr', 'Kerry'),\n", " (4, 'Sarah Heath', 'Monaghan'),\n", " (5, 'Anna Henry', 'Carlow'),\n", " (6, 'Robert Snyder', 'Leitrim')]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT ROWID, name, address FROM person\")\n", "c.fetchall()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## sqlite3 with pandas" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [], "source": [ "c.execute(\"DROP TABLE person\")\n", "conn.commit()" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAddress
ID
0Anna HenryCarlow
1Shelby BeckTipperary
2Marie CarrKerry
3Sarah HeathMonaghan
4Robert SnyderLeitrim
5Lucas RossCork
6David CoxLeitrim
7Jackson DeanLouth
8Elizabeth McfarlandDublin
9Timothy CummingsLimerick
\n", "
" ], "text/plain": [ " Name Address\n", "ID \n", "0 Anna Henry Carlow\n", "1 Shelby Beck Tipperary\n", "2 Marie Carr Kerry\n", "3 Sarah Heath Monaghan\n", "4 Robert Snyder Leitrim\n", "5 Lucas Ross Cork\n", "6 David Cox Leitrim\n", "7 Jackson Dean Louth\n", "8 Elizabeth Mcfarland Dublin\n", "9 Timothy Cummings Limerick" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "person = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/person.csv\", index_col=0)\n", "person.head(10)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "person.to_sql(\"person\", conn)" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [], "source": [ "car = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/car.csv\", index_col=0)\n", "car.to_sql(\"car\", conn)" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [], "source": [ "county = pd.read_csv(\"https://github.com/ianmcloughlin/datasets/raw/master/cars-db/county.csv\", index_col=0)\n", "county.to_sql(\"county\", conn)" ] }, { "cell_type": "code", "execution_count": 29, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[(0, 'CW', 'Carlow'),\n", " (1, 'CN', 'Cavan'),\n", " (2, 'CE', 'Clare'),\n", " (3, 'C', 'Cork'),\n", " (4, 'DL', 'Donegal'),\n", " (5, 'D', 'Dublin'),\n", " (6, 'G', 'Galway'),\n", " (7, 'KY', 'Kerry'),\n", " (8, 'KE', 'Kildare'),\n", " (9, 'KK', 'Kilkenny'),\n", " (10, 'LS', 'Laois'),\n", " (11, 'LM', 'Leitrim'),\n", " (12, 'L', 'Limerick'),\n", " (13, 'LD', 'Longford'),\n", " (14, 'LH', 'Louth'),\n", " (15, 'MO', 'Mayo'),\n", " (16, 'MH', 'Meath'),\n", " (17, 'MN', 'Monaghan'),\n", " (18, 'OY', 'Offaly'),\n", " (19, 'RN', 'Roscommon'),\n", " (20, 'SO', 'Sligo'),\n", " (21, 'T', 'Tipperary'),\n", " (22, 'W', 'Waterford'),\n", " (23, 'WH', 'Westmeath'),\n", " (24, 'WX', 'Wexford'),\n", " (25, 'WW', 'Wicklow')]" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT * FROM county\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('person',), ('car',), ('county',)]" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"SELECT name FROM sqlite_master WHERE type='table'\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Timothy Cummings', '08-SO-11072', 'Limerick'),\n", " ('Dana Wade', '16-KE-16368', 'Mayo'),\n", " ('Valerie Stewart', '08-LD-16871', 'Longford'),\n", " ('Gregory Vazquez', '11-KY-17442', 'Sligo'),\n", " ('Sara Lee', '16-LD-17545', 'Laois'),\n", " ('Jennifer Reeves', '10-WH-3543', 'Offaly'),\n", " ('Leonard Chen', '03-KE-8148', 'Galway'),\n", " ('Robert Snyder', '06-G-23024', 'Leitrim'),\n", " ('Morgan Marsh', '08-LS-21770', 'Westmeath'),\n", " ('Kayla Rodriguez DVM', '03-WX-41717', 'Clare'),\n", " ('Robert Acevedo', '01-T-37495', 'Meath'),\n", " ('Susan Cummings', '11-WH-22446', 'Cork'),\n", " ('Anne Anderson', '09-MN-43311', 'Cork'),\n", " ('Anna Henry', '05-KK-2596', 'Carlow'),\n", " ('Melanie White', '17-SO-17328', 'Carlow'),\n", " ('Justin Casey', '99-L-23440', 'Louth'),\n", " ('Jacob Moore', '05-WX-31122', 'Longford'),\n", " ('Donna Mason', '16-LS-41756', 'Longford'),\n", " ('Leonard Brown', '16-RN-45098', 'Sligo'),\n", " ('Paul Nicholson', '16-C-27251', 'Wexford'),\n", " ('Stephanie Yates', '06-LD-43721', 'Meath'),\n", " ('Connie Walls', '03-RN-2898', 'Limerick'),\n", " ('Tina Holland', '10-CW-49121', 'Sligo'),\n", " ('Nicholas Carrillo', '15-LS-45283', 'Laois'),\n", " ('Anna Henry', '08-D-43986', 'Carlow'),\n", " ('Devin Shaw', '08-DL-49460', 'Wexford'),\n", " ('Melinda Blackwell', '08-DL-20130', 'Mayo'),\n", " ('Robert Snyder', '10-WX-18691', 'Leitrim'),\n", " ('Marie Carr', '08-T-37917', 'Kerry'),\n", " ('David Cox', '15-D-6469', 'Leitrim'),\n", " ('Richard Foley', '08-L-26251', 'Offaly'),\n", " ('Alan Cabrera', '15-DL-15311', 'Leitrim'),\n", " ('Marcus Malone', '14-KE-41007', 'Kildare'),\n", " ('Stephanie Yates', '14-DL-12858', 'Meath'),\n", " ('Diane Hunt', '04-WH-36658', 'Westmeath'),\n", " ('Mrs. Kerry Romero', '00-MO-9632', 'Limerick'),\n", " ('Kathleen Henderson', '99-RN-41288', 'Monaghan'),\n", " ('Mrs. Kerry Romero', '13-MO-7316', 'Limerick'),\n", " ('Gregory Charles', '00-MH-17952', 'Wicklow'),\n", " ('James Williams', '18-LM-29466', 'Kilkenny'),\n", " ('George Fitzgerald', '08-D-18591', 'Carlow'),\n", " ('Stephanie Yates', '01-KK-27583', 'Meath'),\n", " ('Billy King', '13-T-24765', 'Louth'),\n", " ('William Hall', '01-RN-44780', 'Kerry'),\n", " ('Leonard Brown', '04-LD-24948', 'Sligo'),\n", " ('Valerie Rodriguez', '13-SO-2521', 'Kerry'),\n", " ('Leonard Brown', '16-WH-32130', 'Sligo'),\n", " ('Sandra Knight', '13-KE-37707', 'Offaly'),\n", " ('Mrs. Sheila Wilkerson', '99-CN-35366', 'Tipperary'),\n", " ('Marc Chapman', '18-CN-17743', 'Dublin'),\n", " ('Alan Williams', '05-LS-6602', 'Galway'),\n", " ('Donna Mason', '02-T-2683', 'Longford'),\n", " ('Sandra Knight', '06-LD-44064', 'Offaly'),\n", " ('Connie Walls', '14-SO-35322', 'Limerick'),\n", " ('Sarah Heath', '00-MH-30641', 'Monaghan'),\n", " ('Karen Roach', '17-MH-38452', 'Sligo'),\n", " ('Shelby Beck', '01-KY-40015', 'Tipperary'),\n", " ('Laura Miller', '13-G-17426', 'Louth'),\n", " ('Robert Fields', '03-LM-41543', 'Louth'),\n", " ('Mrs. Kerry Romero', '00-LH-46635', 'Limerick'),\n", " ('Dana Wade', '09-SO-26131', 'Mayo'),\n", " ('Glenn Gonzalez', '00-OY-15049', 'Leitrim'),\n", " ('Jesse Chavez', '12-G-20496', 'Meath'),\n", " ('Melinda Blackwell', '04-RN-2959', 'Mayo'),\n", " ('Shelby Beck', '07-KY-17472', 'Tipperary'),\n", " ('James Walker', '03-KY-23864', 'Tipperary'),\n", " ('Robert Price', '03-CW-12234', 'Dublin'),\n", " ('Valerie Rodriguez', '04-LS-17699', 'Kerry'),\n", " ('Melinda Blackwell', '12-MO-21340', 'Mayo'),\n", " ('Raymond Perkins', '14-WW-26729', 'Clare'),\n", " ('Connie Walls', '08-KK-6963', 'Limerick'),\n", " ('Scott Whitaker', '03-D-36946', 'Offaly'),\n", " ('Crystal Murphy', '03-WX-39739', 'Clare'),\n", " ('Timothy Cummings', '15-MO-29166', 'Limerick'),\n", " ('Kayla Rodriguez DVM', '09-LM-6757', 'Clare'),\n", " ('Marie Carr', '99-LD-27879', 'Kerry'),\n", " ('Raymond Perkins', '16-WX-38806', 'Clare'),\n", " ('Nicholas Carrillo', '06-KE-13830', 'Laois'),\n", " ('Emily Alvarado', '00-OY-18653', 'Longford'),\n", " ('Mrs. Kerry Romero', '09-G-14895', 'Limerick'),\n", " ('Scott Whitaker', '06-LH-39166', 'Offaly'),\n", " ('Morgan Marsh', '10-MO-45154', 'Westmeath'),\n", " ('Elizabeth Harper', '04-WH-37901', 'Donegal'),\n", " ('Stephen Oneal', '13-DL-46087', 'Louth'),\n", " ('Justin Casey', '14-CN-12576', 'Louth'),\n", " ('Frederick Schwartz', '15-D-4470', 'Dublin'),\n", " ('Christopher Mcmahon', '00-MO-32274', 'Limerick'),\n", " ('Paul Nicholson', '15-WH-21313', 'Wexford'),\n", " ('Melinda Blackwell', '08-D-29496', 'Mayo'),\n", " ('Peter Vaughn DDS', '00-LD-24730', 'Cork'),\n", " ('Gregory Charles', '14-OY-15669', 'Wicklow'),\n", " ('Peter Vaughn DDS', '00-MO-6904', 'Cork'),\n", " ('Lucas Ross', '17-DL-4885', 'Cork'),\n", " ('Jenny Juarez', '05-MN-17446', 'Longford'),\n", " ('Jordan Velasquez', '04-L-19474', 'Galway'),\n", " ('Alan Williams', '99-WW-237', 'Galway'),\n", " ('Kerry Curry', '03-G-36241', 'Galway'),\n", " ('Sarah Heath', '09-W-11201', 'Monaghan'),\n", " ('Robert Acevedo', '13-MO-34031', 'Meath'),\n", " ('Tina Holland', '02-KK-25507', 'Sligo'),\n", " ('Rachel Johnson', '08-LH-46637', 'Kildare'),\n", " ('Paul Nicholson', '12-KY-47631', 'Wexford'),\n", " ('Jennifer Sutton', '01-SO-45136', 'Mayo'),\n", " ('Jeremiah Soto', '18-WH-15349', 'Sligo'),\n", " ('Jeremiah Soto', '14-MO-11345', 'Sligo'),\n", " ('Laura Miller', '13-CE-10371', 'Louth'),\n", " ('Frederick Schwartz', '17-KE-21153', 'Dublin'),\n", " ('Rachel Johnson', '12-G-30288', 'Kildare'),\n", " ('Jacob Moore', '13-T-20412', 'Longford'),\n", " ('Lucas Ross', '08-LS-13835', 'Cork'),\n", " ('Devin Shaw', '12-CW-37691', 'Wexford'),\n", " ('Sarah Heath', '00-KY-48702', 'Monaghan'),\n", " ('Connie Walls', '14-LD-41919', 'Limerick'),\n", " ('Laura Miller', '18-W-16094', 'Louth'),\n", " ('Jacob Moore', '11-MH-39456', 'Longford'),\n", " ('Rachel Johnson', '01-KK-21586', 'Kildare'),\n", " ('Sandra Knight', '09-WX-7243', 'Offaly'),\n", " ('Megan Clarke', '12-WX-26308', 'Kildare'),\n", " ('Tina Holland', '02-LS-42993', 'Sligo'),\n", " ('Nicholas Carrillo', '18-W-44751', 'Laois'),\n", " ('Leonard Chen', '11-L-45810', 'Galway'),\n", " ('Raymond Perkins', '12-MH-7025', 'Clare'),\n", " ('Diane Hunt', '09-CW-13802', 'Westmeath'),\n", " ('Nicholas Carrillo', '11-KK-40419', 'Laois'),\n", " ('Connie Walls', '09-MO-27719', 'Limerick'),\n", " ('Rachel Johnson', '99-RN-21293', 'Kildare'),\n", " ('Raymond Gould', '06-KK-24445', 'Clare'),\n", " ('Dana Wade', '99-DL-44188', 'Mayo'),\n", " ('Lucas Ross', '17-CW-12306', 'Cork'),\n", " ('Melanie White', '12-WH-30512', 'Carlow'),\n", " ('Donna Mason', '13-CW-22728', 'Longford'),\n", " ('Jordan Velasquez', '15-G-27780', 'Galway'),\n", " ('Morgan Marsh', '99-WX-37648', 'Westmeath'),\n", " ('Katherine Dalton', '07-G-30931', 'Kildare'),\n", " ('Mrs. Kerry Romero', '08-G-34713', 'Limerick'),\n", " ('Peter Vaughn DDS', '03-MO-23757', 'Cork'),\n", " ('Morgan Marsh', '09-LD-32395', 'Westmeath'),\n", " ('Donna Mason', '05-KE-47018', 'Longford'),\n", " ('Susan Cummings', '18-RN-21403', 'Cork'),\n", " ('Paul Raymond', '02-LH-37988', 'Louth'),\n", " ('Kathleen Henderson', '11-T-29849', 'Monaghan'),\n", " ('Alan Williams', '99-MN-36507', 'Galway'),\n", " ('Gregory Charles', '15-SO-10080', 'Wicklow'),\n", " ('Valerie Rodriguez', '10-KE-5471', 'Kerry'),\n", " ('Susan Cummings', '09-C-15081', 'Cork'),\n", " ('Shelby Beck', '12-D-10674', 'Tipperary'),\n", " ('Jeff Stevens', '16-KK-6777', 'Dublin'),\n", " ('Nathan Smith', '09-KY-24502', 'Roscommon'),\n", " ('Jeff Stevens', '06-L-13615', 'Dublin'),\n", " ('Marcus Malone', '11-WX-6607', 'Kildare'),\n", " ('Jesse Chavez', '99-KY-44876', 'Meath'),\n", " ('Susan Cummings', '01-KE-7495', 'Cork'),\n", " ('Justin Casey', '06-WH-45961', 'Louth'),\n", " ('Shannon Oneal', '13-RN-48840', 'Sligo'),\n", " ('Melissa Bell', '15-LS-32504', 'Kildare'),\n", " ('Kayla Rodriguez DVM', '09-KK-33938', 'Clare'),\n", " ('Leonard Brown', '15-SO-48732', 'Sligo'),\n", " ('Tina Holland', '18-LH-9276', 'Sligo'),\n", " ('Jennifer Reeves', '00-T-13145', 'Offaly'),\n", " ('Donna Mason', '17-L-8077', 'Longford'),\n", " ('Raymond Perkins', '16-KY-38486', 'Clare'),\n", " ('Kathleen Henderson', '13-C-5004', 'Monaghan'),\n", " ('Sabrina Thompson', '13-KE-8122', 'Longford'),\n", " ('Elizabeth Mcfarland', '13-D-16232', 'Dublin'),\n", " ('Tracey Olson', '07-OY-29590', 'Kilkenny'),\n", " ('John Davis', '18-LS-3902', 'Dublin'),\n", " ('Christina Bautista', '07-LD-25411', 'Longford'),\n", " ('Seth Simpson', '11-OY-49718', 'Westmeath'),\n", " ('Emily Cooper', '09-OY-12095', 'Kildare'),\n", " ('Emily Alvarado', '10-RN-14168', 'Longford'),\n", " ('Jenny Juarez', '00-CN-12132', 'Longford'),\n", " ('Peter Vaughn DDS', '14-G-24691', 'Cork'),\n", " ('Connie Walls', '08-L-9335', 'Limerick'),\n", " ('Mrs. Kerry Romero', '13-LS-7544', 'Limerick'),\n", " ('Sandra Knight', '15-RN-47108', 'Offaly'),\n", " ('Devin Shaw', '16-RN-12605', 'Wexford'),\n", " ('Jenny Juarez', '15-WX-13974', 'Longford'),\n", " ('Alan Williams', '00-T-26883', 'Galway'),\n", " ('Carrie Sullivan', '01-C-1695', 'Galway'),\n", " ('Alan Williams', '11-WW-3780', 'Galway'),\n", " ('Tina Holland', '06-CW-29425', 'Sligo'),\n", " ('Laura Miller', '04-MN-1637', 'Louth'),\n", " ('Raymond Perkins', '14-OY-39752', 'Clare'),\n", " ('Justin Casey', '15-MO-15513', 'Louth'),\n", " ('Robert Price', '16-MN-22976', 'Dublin'),\n", " ('Christopher Miller', '07-OY-14928', 'Kerry'),\n", " ('Gregory Vazquez', '09-L-10881', 'Sligo'),\n", " ('Daniel Smith', '99-WX-23085', 'Limerick'),\n", " ('Valerie Rodriguez', '01-DL-25359', 'Kerry'),\n", " ('Elizabeth Harper', '00-MO-45664', 'Donegal'),\n", " ('Daniel Smith', '08-WW-30636', 'Limerick'),\n", " ('Megan Clarke', '01-CN-16097', 'Kildare'),\n", " ('Tina Holland', '07-LM-3132', 'Sligo'),\n", " ('Marc Chapman', '09-T-9813', 'Dublin'),\n", " ('Anna Henry', '16-KK-30424', 'Carlow'),\n", " ('Jesse Chavez', '99-CE-38547', 'Meath'),\n", " ('Sarah Heath', '10-LM-31279', 'Monaghan'),\n", " ('Paul Nicholson', '18-LH-44089', 'Wexford'),\n", " ('David Matthews', '02-SO-11359', 'Leitrim'),\n", " ('Elizabeth Mcfarland', '10-KE-33674', 'Dublin'),\n", " ('George Fitzgerald', '15-KE-8245', 'Carlow'),\n", " ('Raymond Perkins', '09-KK-23170', 'Clare'),\n", " ('Christopher Mcmahon', '14-CN-36381', 'Limerick'),\n", " ('Christina Bautista', '00-C-29416', 'Longford'),\n", " ('Christopher Mcmahon', '10-OY-1992', 'Limerick'),\n", " ('David Matthews', '10-T-36797', 'Leitrim'),\n", " ('Rachel Johnson', '07-KY-35080', 'Kildare'),\n", " ('Gail Jones', '08-MO-42969', 'Waterford'),\n", " ('Jeff Stevens', '07-OY-23008', 'Dublin'),\n", " ('Joseph Griffith', '14-MO-46320', 'Wicklow'),\n", " ('Katherine Dalton', '09-CW-29560', 'Kildare'),\n", " ('Devin Shaw', '03-MH-49587', 'Wexford'),\n", " ('Paul Raymond', '10-MH-34061', 'Louth'),\n", " ('Lucas Ross', '08-OY-35517', 'Cork'),\n", " ('Peter Vaughn DDS', '04-KY-47667', 'Cork'),\n", " ('Gregory Vazquez', '03-C-18358', 'Sligo'),\n", " ('Marcus Malone', '11-DL-2662', 'Kildare'),\n", " ('Gail Jones', '06-CW-15872', 'Waterford'),\n", " ('Jenny Juarez', '08-KE-7824', 'Longford'),\n", " ('Sabrina Thompson', '14-WH-21137', 'Longford'),\n", " ('Kathleen Henderson', '11-W-6130', 'Monaghan'),\n", " ('Raymond Gould', '03-C-4508', 'Clare'),\n", " ('Elizabeth Mcfarland', '02-CN-35760', 'Dublin'),\n", " ('Megan Clarke', '13-C-5330', 'Kildare'),\n", " ('Justin Casey', '07-CN-40170', 'Louth'),\n", " ('Valerie Rodriguez', '07-CW-32094', 'Kerry'),\n", " ('Alan Williams', '13-CW-22639', 'Galway'),\n", " ('Alan Williams', '10-LD-39262', 'Galway'),\n", " ('Stephanie Yates', '14-CE-46501', 'Meath'),\n", " ('Susan Cummings', '16-WW-18559', 'Cork'),\n", " ('Christopher Miller', '11-LD-42457', 'Kerry'),\n", " ('Shannon Oneal', '02-W-35723', 'Sligo'),\n", " ('Tina Holland', '13-RN-4833', 'Sligo'),\n", " ('Karen Roach', '01-KK-12540', 'Sligo'),\n", " ('Laura Miller', '14-CN-39530', 'Louth'),\n", " ('Carrie Sullivan', '08-T-1665', 'Galway'),\n", " ('Frederick Schwartz', '13-LH-30593', 'Dublin'),\n", " ('Carrie Sullivan', '06-C-24008', 'Galway'),\n", " ('Megan Clarke', '12-LH-5689', 'Kildare'),\n", " ('Leonard Chen', '05-WW-47977', 'Galway'),\n", " ('Susan Cummings', '09-KK-5328', 'Cork'),\n", " ('Marie Carr', '10-DL-6386', 'Kerry'),\n", " ('John Davis', '05-MH-22339', 'Dublin'),\n", " ('Jackson Dean', '02-MH-44541', 'Louth'),\n", " ('Jesse Chavez', '18-MN-26444', 'Meath'),\n", " ('Gregory Charles', '12-LM-22338', 'Wicklow'),\n", " ('Devin Shaw', '18-KY-29981', 'Wexford'),\n", " ('Laura Miller', '01-G-8684', 'Louth'),\n", " ('Marc Chapman', '04-KY-32797', 'Dublin'),\n", " ('Paul Nicholson', '08-LD-12240', 'Wexford'),\n", " ('Donna Mason', '18-WW-11514', 'Longford'),\n", " ('Dana Wade', '03-L-40377', 'Mayo'),\n", " ('Jenny Juarez', '15-G-37225', 'Longford'),\n", " ('Emily Alvarado', '14-CN-41515', 'Longford'),\n", " ('Robert Fields', '09-LS-131', 'Louth'),\n", " ('David Cox', '12-LS-47102', 'Leitrim'),\n", " ('Alan Cabrera', '15-WX-8189', 'Leitrim'),\n", " ('Donna Mason', '13-CW-21688', 'Longford'),\n", " ('John Davis', '15-DL-3247', 'Dublin'),\n", " ('Raymond Perkins', '02-D-22267', 'Clare'),\n", " ('Robert Acevedo', '01-LS-33323', 'Meath'),\n", " ('Peter Vaughn DDS', '10-WH-9955', 'Cork'),\n", " ('Joseph Griffith', '03-MO-4365', 'Wicklow'),\n", " ('Joseph Griffith', '04-LD-23688', 'Wicklow'),\n", " ('Alan Williams', '13-G-16885', 'Galway'),\n", " ('Jenny Juarez', '18-KE-36389', 'Longford'),\n", " ('Melissa Lowe', '01-T-15866', 'Westmeath'),\n", " ('Christopher Miller', '08-KE-16056', 'Kerry'),\n", " ('Kayla Rodriguez DVM', '13-G-24475', 'Clare'),\n", " ('Emily Cooper', '03-MO-25665', 'Kildare'),\n", " ('Stephanie Yates', '18-T-2425', 'Meath'),\n", " ('Elizabeth Harper', '04-WW-24305', 'Donegal'),\n", " ('Shannon Oneal', '13-OY-23701', 'Sligo'),\n", " ('David Matthews', '08-MO-46007', 'Leitrim'),\n", " ('Robert Price', '00-L-47267', 'Dublin'),\n", " ('Emily Cooper', '08-KK-47849', 'Kildare'),\n", " ('Elizabeth Harper', '16-MN-41115', 'Donegal'),\n", " ('Dana Wade', '02-DL-7526', 'Mayo'),\n", " ('Melanie White', '01-G-15863', 'Carlow'),\n", " ('Elizabeth Harper', '14-SO-6402', 'Donegal'),\n", " ('Lori Harmon', '02-CN-7196', 'Carlow'),\n", " ('Christopher Mcmahon', '01-CW-35670', 'Limerick'),\n", " ('Sandra Knight', '16-T-45794', 'Offaly'),\n", " ('Anna Henry', '03-KK-1616', 'Carlow'),\n", " ('Jennifer Reeves', '08-WX-43305', 'Offaly'),\n", " ('Mrs. Sheila Wilkerson', '15-W-31836', 'Tipperary'),\n", " ('Susan Cummings', '03-KE-1400', 'Cork'),\n", " ('Jared Nguyen', '08-WW-22857', 'Cavan'),\n", " ('Elizabeth Harper', '15-L-48040', 'Donegal'),\n", " ('Stephanie Yates', '05-CN-49186', 'Meath'),\n", " ('Tracey Olson', '18-T-43669', 'Kilkenny'),\n", " ('John Davis', '05-WX-40194', 'Dublin'),\n", " ('Anna Henry', '08-LH-30886', 'Carlow'),\n", " ('Melanie White', '07-G-36331', 'Carlow'),\n", " ('Leonard Chen', '06-WW-48865', 'Galway'),\n", " ('Leonard Brown', '16-MO-40801', 'Sligo'),\n", " ('George Fitzgerald', '15-L-37732', 'Carlow'),\n", " ('Gail Jones', '10-G-21752', 'Waterford'),\n", " ('Susan Cummings', '08-C-34297', 'Cork'),\n", " ('Jacob Moore', '17-SO-23443', 'Longford'),\n", " ('Dana Wade', '05-CN-5924', 'Mayo'),\n", " ('David Cox', '05-W-22770', 'Leitrim'),\n", " ('Joshua Perez', '10-LH-34050', 'Galway'),\n", " ('Robert Fields', '16-LS-26245', 'Louth'),\n", " ('Hannah Collier', '05-D-30917', 'Leitrim'),\n", " ('Dana Wade', '07-G-48955', 'Mayo'),\n", " ('Diane Hunt', '13-G-48846', 'Westmeath'),\n", " ('Megan Clarke', '05-L-42386', 'Kildare'),\n", " ('Richard Foley', '08-T-12971', 'Offaly'),\n", " ('Carrie Sullivan', '18-WH-6082', 'Galway'),\n", " ('Daniel Smith', '12-MO-30235', 'Limerick'),\n", " ('John Davis', '16-T-22243', 'Dublin'),\n", " ('Jeff Stevens', '03-L-37130', 'Dublin'),\n", " ('Devin Shaw', '12-MO-18353', 'Wexford'),\n", " ('Robert Fields', '11-MN-11186', 'Louth'),\n", " ('Robert Price', '05-WX-40062', 'Dublin'),\n", " ('Melissa Lowe', '04-D-38409', 'Westmeath'),\n", " ('William Hall', '16-CE-29807', 'Kerry'),\n", " ('Joseph Griffith', '15-D-4632', 'Wicklow'),\n", " ('Joshua Perez', '14-LM-31240', 'Galway'),\n", " ('David Cox', '15-LH-20280', 'Leitrim'),\n", " ('Jeff Stevens', '04-L-14265', 'Dublin'),\n", " ('Sandra Knight', '05-KK-13066', 'Offaly'),\n", " ('Jordan Velasquez', '02-MN-14407', 'Galway'),\n", " ('Jared Nguyen', '11-CE-42446', 'Cavan'),\n", " ('Melissa Lowe', '16-W-29168', 'Westmeath'),\n", " ('Katherine Dalton', '03-G-19542', 'Kildare'),\n", " ('Hannah Collier', '18-MO-35400', 'Leitrim'),\n", " ('Alan Williams', '11-KK-35894', 'Galway'),\n", " ('Seth Simpson', '07-G-5958', 'Westmeath')]" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"\"\"\n", " SELECT p.Name, c.Registration, p.Address\n", " FROM person as p JOIN car as c ON p.ID = c.OwnerId\n", "\"\"\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Timothy Cummings', '08-SO-11072', 'Limerick'),\n", " ('Dana Wade', '16-KE-16368', 'Mayo'),\n", " ('Valerie Stewart', '08-LD-16871', 'Longford'),\n", " ('Gregory Vazquez', '11-KY-17442', 'Sligo'),\n", " ('Sara Lee', '16-LD-17545', 'Laois'),\n", " ('Jennifer Reeves', '10-WH-3543', 'Offaly'),\n", " ('Leonard Chen', '03-KE-8148', 'Galway'),\n", " ('Robert Snyder', '06-G-23024', 'Leitrim'),\n", " ('Morgan Marsh', '08-LS-21770', 'Westmeath'),\n", " ('Kayla Rodriguez DVM', '03-WX-41717', 'Clare'),\n", " ('Robert Acevedo', '01-T-37495', 'Meath'),\n", " ('Susan Cummings', '11-WH-22446', 'Cork'),\n", " ('Anne Anderson', '09-MN-43311', 'Cork'),\n", " ('Anna Henry', '05-KK-2596', 'Carlow'),\n", " ('Melanie White', '17-SO-17328', 'Carlow'),\n", " ('Justin Casey', '99-L-23440', 'Louth'),\n", " ('Jacob Moore', '05-WX-31122', 'Longford'),\n", " ('Donna Mason', '16-LS-41756', 'Longford'),\n", " ('Leonard Brown', '16-RN-45098', 'Sligo'),\n", " ('Paul Nicholson', '16-C-27251', 'Wexford'),\n", " ('Stephanie Yates', '06-LD-43721', 'Meath'),\n", " ('Connie Walls', '03-RN-2898', 'Limerick'),\n", " ('Tina Holland', '10-CW-49121', 'Sligo'),\n", " ('Nicholas Carrillo', '15-LS-45283', 'Laois'),\n", " ('Anna Henry', '08-D-43986', 'Carlow'),\n", " ('Devin Shaw', '08-DL-49460', 'Wexford'),\n", " ('Melinda Blackwell', '08-DL-20130', 'Mayo'),\n", " ('Robert Snyder', '10-WX-18691', 'Leitrim'),\n", " ('Marie Carr', '08-T-37917', 'Kerry'),\n", " ('David Cox', '15-D-6469', 'Leitrim'),\n", " ('Richard Foley', '08-L-26251', 'Offaly'),\n", " ('Alan Cabrera', '15-DL-15311', 'Leitrim'),\n", " ('Marcus Malone', '14-KE-41007', 'Kildare'),\n", " ('Stephanie Yates', '14-DL-12858', 'Meath'),\n", " ('Diane Hunt', '04-WH-36658', 'Westmeath'),\n", " ('Mrs. Kerry Romero', '00-MO-9632', 'Limerick'),\n", " ('Kathleen Henderson', '99-RN-41288', 'Monaghan'),\n", " ('Mrs. Kerry Romero', '13-MO-7316', 'Limerick'),\n", " ('Gregory Charles', '00-MH-17952', 'Wicklow'),\n", " ('James Williams', '18-LM-29466', 'Kilkenny'),\n", " ('George Fitzgerald', '08-D-18591', 'Carlow'),\n", " ('Stephanie Yates', '01-KK-27583', 'Meath'),\n", " ('Billy King', '13-T-24765', 'Louth'),\n", " ('William Hall', '01-RN-44780', 'Kerry'),\n", " ('Leonard Brown', '04-LD-24948', 'Sligo'),\n", " ('Valerie Rodriguez', '13-SO-2521', 'Kerry'),\n", " ('Leonard Brown', '16-WH-32130', 'Sligo'),\n", " ('Sandra Knight', '13-KE-37707', 'Offaly'),\n", " ('Mrs. Sheila Wilkerson', '99-CN-35366', 'Tipperary'),\n", " ('Marc Chapman', '18-CN-17743', 'Dublin'),\n", " ('Alan Williams', '05-LS-6602', 'Galway'),\n", " ('Donna Mason', '02-T-2683', 'Longford'),\n", " ('Sandra Knight', '06-LD-44064', 'Offaly'),\n", " ('Connie Walls', '14-SO-35322', 'Limerick'),\n", " ('Sarah Heath', '00-MH-30641', 'Monaghan'),\n", " ('Karen Roach', '17-MH-38452', 'Sligo'),\n", " ('Shelby Beck', '01-KY-40015', 'Tipperary'),\n", " ('Laura Miller', '13-G-17426', 'Louth'),\n", " ('Robert Fields', '03-LM-41543', 'Louth'),\n", " ('Mrs. Kerry Romero', '00-LH-46635', 'Limerick'),\n", " ('Dana Wade', '09-SO-26131', 'Mayo'),\n", " ('Glenn Gonzalez', '00-OY-15049', 'Leitrim'),\n", " ('Jesse Chavez', '12-G-20496', 'Meath'),\n", " ('Melinda Blackwell', '04-RN-2959', 'Mayo'),\n", " ('Shelby Beck', '07-KY-17472', 'Tipperary'),\n", " ('James Walker', '03-KY-23864', 'Tipperary'),\n", " ('Robert Price', '03-CW-12234', 'Dublin'),\n", " ('Valerie Rodriguez', '04-LS-17699', 'Kerry'),\n", " ('Melinda Blackwell', '12-MO-21340', 'Mayo'),\n", " ('Raymond Perkins', '14-WW-26729', 'Clare'),\n", " ('Connie Walls', '08-KK-6963', 'Limerick'),\n", " ('Scott Whitaker', '03-D-36946', 'Offaly'),\n", " ('Crystal Murphy', '03-WX-39739', 'Clare'),\n", " ('Timothy Cummings', '15-MO-29166', 'Limerick'),\n", " ('Kayla Rodriguez DVM', '09-LM-6757', 'Clare'),\n", " ('Marie Carr', '99-LD-27879', 'Kerry'),\n", " ('Raymond Perkins', '16-WX-38806', 'Clare'),\n", " ('Nicholas Carrillo', '06-KE-13830', 'Laois'),\n", " ('Emily Alvarado', '00-OY-18653', 'Longford'),\n", " ('Mrs. Kerry Romero', '09-G-14895', 'Limerick'),\n", " ('Scott Whitaker', '06-LH-39166', 'Offaly'),\n", " ('Morgan Marsh', '10-MO-45154', 'Westmeath'),\n", " ('Elizabeth Harper', '04-WH-37901', 'Donegal'),\n", " ('Stephen Oneal', '13-DL-46087', 'Louth'),\n", " ('Justin Casey', '14-CN-12576', 'Louth'),\n", " ('Frederick Schwartz', '15-D-4470', 'Dublin'),\n", " ('Christopher Mcmahon', '00-MO-32274', 'Limerick'),\n", " ('Paul Nicholson', '15-WH-21313', 'Wexford'),\n", " ('Melinda Blackwell', '08-D-29496', 'Mayo'),\n", " ('Peter Vaughn DDS', '00-LD-24730', 'Cork'),\n", " ('Gregory Charles', '14-OY-15669', 'Wicklow'),\n", " ('Peter Vaughn DDS', '00-MO-6904', 'Cork'),\n", " ('Lucas Ross', '17-DL-4885', 'Cork'),\n", " ('Jenny Juarez', '05-MN-17446', 'Longford'),\n", " ('Jordan Velasquez', '04-L-19474', 'Galway'),\n", " ('Alan Williams', '99-WW-237', 'Galway'),\n", " ('Kerry Curry', '03-G-36241', 'Galway'),\n", " ('Sarah Heath', '09-W-11201', 'Monaghan'),\n", " ('Robert Acevedo', '13-MO-34031', 'Meath'),\n", " ('Tina Holland', '02-KK-25507', 'Sligo'),\n", " ('Rachel Johnson', '08-LH-46637', 'Kildare'),\n", " ('Paul Nicholson', '12-KY-47631', 'Wexford'),\n", " ('Jennifer Sutton', '01-SO-45136', 'Mayo'),\n", " ('Jeremiah Soto', '18-WH-15349', 'Sligo'),\n", " ('Jeremiah Soto', '14-MO-11345', 'Sligo'),\n", " ('Laura Miller', '13-CE-10371', 'Louth'),\n", " ('Frederick Schwartz', '17-KE-21153', 'Dublin'),\n", " ('Rachel Johnson', '12-G-30288', 'Kildare'),\n", " ('Jacob Moore', '13-T-20412', 'Longford'),\n", " ('Lucas Ross', '08-LS-13835', 'Cork'),\n", " ('Devin Shaw', '12-CW-37691', 'Wexford'),\n", " ('Sarah Heath', '00-KY-48702', 'Monaghan'),\n", " ('Connie Walls', '14-LD-41919', 'Limerick'),\n", " ('Laura Miller', '18-W-16094', 'Louth'),\n", " ('Jacob Moore', '11-MH-39456', 'Longford'),\n", " ('Rachel Johnson', '01-KK-21586', 'Kildare'),\n", " ('Sandra Knight', '09-WX-7243', 'Offaly'),\n", " ('Megan Clarke', '12-WX-26308', 'Kildare'),\n", " ('Tina Holland', '02-LS-42993', 'Sligo'),\n", " ('Nicholas Carrillo', '18-W-44751', 'Laois'),\n", " ('Leonard Chen', '11-L-45810', 'Galway'),\n", " ('Raymond Perkins', '12-MH-7025', 'Clare'),\n", " ('Diane Hunt', '09-CW-13802', 'Westmeath'),\n", " ('Nicholas Carrillo', '11-KK-40419', 'Laois'),\n", " ('Connie Walls', '09-MO-27719', 'Limerick'),\n", " ('Rachel Johnson', '99-RN-21293', 'Kildare'),\n", " ('Raymond Gould', '06-KK-24445', 'Clare'),\n", " ('Dana Wade', '99-DL-44188', 'Mayo'),\n", " ('Lucas Ross', '17-CW-12306', 'Cork'),\n", " ('Melanie White', '12-WH-30512', 'Carlow'),\n", " ('Donna Mason', '13-CW-22728', 'Longford'),\n", " ('Jordan Velasquez', '15-G-27780', 'Galway'),\n", " ('Morgan Marsh', '99-WX-37648', 'Westmeath'),\n", " ('Katherine Dalton', '07-G-30931', 'Kildare'),\n", " ('Mrs. Kerry Romero', '08-G-34713', 'Limerick'),\n", " ('Peter Vaughn DDS', '03-MO-23757', 'Cork'),\n", " ('Morgan Marsh', '09-LD-32395', 'Westmeath'),\n", " ('Donna Mason', '05-KE-47018', 'Longford'),\n", " ('Susan Cummings', '18-RN-21403', 'Cork'),\n", " ('Paul Raymond', '02-LH-37988', 'Louth'),\n", " ('Kathleen Henderson', '11-T-29849', 'Monaghan'),\n", " ('Alan Williams', '99-MN-36507', 'Galway'),\n", " ('Gregory Charles', '15-SO-10080', 'Wicklow'),\n", " ('Valerie Rodriguez', '10-KE-5471', 'Kerry'),\n", " ('Susan Cummings', '09-C-15081', 'Cork'),\n", " ('Shelby Beck', '12-D-10674', 'Tipperary'),\n", " ('Jeff Stevens', '16-KK-6777', 'Dublin'),\n", " ('Nathan Smith', '09-KY-24502', 'Roscommon'),\n", " ('Jeff Stevens', '06-L-13615', 'Dublin'),\n", " ('Marcus Malone', '11-WX-6607', 'Kildare'),\n", " ('Jesse Chavez', '99-KY-44876', 'Meath'),\n", " ('Susan Cummings', '01-KE-7495', 'Cork'),\n", " ('Justin Casey', '06-WH-45961', 'Louth'),\n", " ('Shannon Oneal', '13-RN-48840', 'Sligo'),\n", " ('Melissa Bell', '15-LS-32504', 'Kildare'),\n", " ('Kayla Rodriguez DVM', '09-KK-33938', 'Clare'),\n", " ('Leonard Brown', '15-SO-48732', 'Sligo'),\n", " ('Tina Holland', '18-LH-9276', 'Sligo'),\n", " ('Jennifer Reeves', '00-T-13145', 'Offaly'),\n", " ('Donna Mason', '17-L-8077', 'Longford'),\n", " ('Raymond Perkins', '16-KY-38486', 'Clare'),\n", " ('Kathleen Henderson', '13-C-5004', 'Monaghan'),\n", " ('Sabrina Thompson', '13-KE-8122', 'Longford'),\n", " ('Elizabeth Mcfarland', '13-D-16232', 'Dublin'),\n", " ('Tracey Olson', '07-OY-29590', 'Kilkenny'),\n", " ('John Davis', '18-LS-3902', 'Dublin'),\n", " ('Christina Bautista', '07-LD-25411', 'Longford'),\n", " ('Seth Simpson', '11-OY-49718', 'Westmeath'),\n", " ('Emily Cooper', '09-OY-12095', 'Kildare'),\n", " ('Emily Alvarado', '10-RN-14168', 'Longford'),\n", " ('Jenny Juarez', '00-CN-12132', 'Longford'),\n", " ('Peter Vaughn DDS', '14-G-24691', 'Cork'),\n", " ('Connie Walls', '08-L-9335', 'Limerick'),\n", " ('Mrs. Kerry Romero', '13-LS-7544', 'Limerick'),\n", " ('Sandra Knight', '15-RN-47108', 'Offaly'),\n", " ('Devin Shaw', '16-RN-12605', 'Wexford'),\n", " ('Jenny Juarez', '15-WX-13974', 'Longford'),\n", " ('Alan Williams', '00-T-26883', 'Galway'),\n", " ('Carrie Sullivan', '01-C-1695', 'Galway'),\n", " ('Alan Williams', '11-WW-3780', 'Galway'),\n", " ('Tina Holland', '06-CW-29425', 'Sligo'),\n", " ('Laura Miller', '04-MN-1637', 'Louth'),\n", " ('Raymond Perkins', '14-OY-39752', 'Clare'),\n", " ('Justin Casey', '15-MO-15513', 'Louth'),\n", " ('Robert Price', '16-MN-22976', 'Dublin'),\n", " ('Christopher Miller', '07-OY-14928', 'Kerry'),\n", " ('Gregory Vazquez', '09-L-10881', 'Sligo'),\n", " ('Daniel Smith', '99-WX-23085', 'Limerick'),\n", " ('Valerie Rodriguez', '01-DL-25359', 'Kerry'),\n", " ('Elizabeth Harper', '00-MO-45664', 'Donegal'),\n", " ('Daniel Smith', '08-WW-30636', 'Limerick'),\n", " ('Megan Clarke', '01-CN-16097', 'Kildare'),\n", " ('Tina Holland', '07-LM-3132', 'Sligo'),\n", " ('Marc Chapman', '09-T-9813', 'Dublin'),\n", " ('Anna Henry', '16-KK-30424', 'Carlow'),\n", " ('Jesse Chavez', '99-CE-38547', 'Meath'),\n", " ('Sarah Heath', '10-LM-31279', 'Monaghan'),\n", " ('Paul Nicholson', '18-LH-44089', 'Wexford'),\n", " ('David Matthews', '02-SO-11359', 'Leitrim'),\n", " ('Elizabeth Mcfarland', '10-KE-33674', 'Dublin'),\n", " ('George Fitzgerald', '15-KE-8245', 'Carlow'),\n", " ('Raymond Perkins', '09-KK-23170', 'Clare'),\n", " ('Christopher Mcmahon', '14-CN-36381', 'Limerick'),\n", " ('Christina Bautista', '00-C-29416', 'Longford'),\n", " ('Christopher Mcmahon', '10-OY-1992', 'Limerick'),\n", " ('David Matthews', '10-T-36797', 'Leitrim'),\n", " ('Rachel Johnson', '07-KY-35080', 'Kildare'),\n", " ('Gail Jones', '08-MO-42969', 'Waterford'),\n", " ('Jeff Stevens', '07-OY-23008', 'Dublin'),\n", " ('Joseph Griffith', '14-MO-46320', 'Wicklow'),\n", " ('Katherine Dalton', '09-CW-29560', 'Kildare'),\n", " ('Devin Shaw', '03-MH-49587', 'Wexford'),\n", " ('Paul Raymond', '10-MH-34061', 'Louth'),\n", " ('Lucas Ross', '08-OY-35517', 'Cork'),\n", " ('Peter Vaughn DDS', '04-KY-47667', 'Cork'),\n", " ('Gregory Vazquez', '03-C-18358', 'Sligo'),\n", " ('Marcus Malone', '11-DL-2662', 'Kildare'),\n", " ('Gail Jones', '06-CW-15872', 'Waterford'),\n", " ('Jenny Juarez', '08-KE-7824', 'Longford'),\n", " ('Sabrina Thompson', '14-WH-21137', 'Longford'),\n", " ('Kathleen Henderson', '11-W-6130', 'Monaghan'),\n", " ('Raymond Gould', '03-C-4508', 'Clare'),\n", " ('Elizabeth Mcfarland', '02-CN-35760', 'Dublin'),\n", " ('Megan Clarke', '13-C-5330', 'Kildare'),\n", " ('Justin Casey', '07-CN-40170', 'Louth'),\n", " ('Valerie Rodriguez', '07-CW-32094', 'Kerry'),\n", " ('Alan Williams', '13-CW-22639', 'Galway'),\n", " ('Alan Williams', '10-LD-39262', 'Galway'),\n", " ('Stephanie Yates', '14-CE-46501', 'Meath'),\n", " ('Susan Cummings', '16-WW-18559', 'Cork'),\n", " ('Christopher Miller', '11-LD-42457', 'Kerry'),\n", " ('Shannon Oneal', '02-W-35723', 'Sligo'),\n", " ('Tina Holland', '13-RN-4833', 'Sligo'),\n", " ('Karen Roach', '01-KK-12540', 'Sligo'),\n", " ('Laura Miller', '14-CN-39530', 'Louth'),\n", " ('Carrie Sullivan', '08-T-1665', 'Galway'),\n", " ('Frederick Schwartz', '13-LH-30593', 'Dublin'),\n", " ('Carrie Sullivan', '06-C-24008', 'Galway'),\n", " ('Megan Clarke', '12-LH-5689', 'Kildare'),\n", " ('Leonard Chen', '05-WW-47977', 'Galway'),\n", " ('Susan Cummings', '09-KK-5328', 'Cork'),\n", " ('Marie Carr', '10-DL-6386', 'Kerry'),\n", " ('John Davis', '05-MH-22339', 'Dublin'),\n", " ('Jackson Dean', '02-MH-44541', 'Louth'),\n", " ('Jesse Chavez', '18-MN-26444', 'Meath'),\n", " ('Gregory Charles', '12-LM-22338', 'Wicklow'),\n", " ('Devin Shaw', '18-KY-29981', 'Wexford'),\n", " ('Laura Miller', '01-G-8684', 'Louth'),\n", " ('Marc Chapman', '04-KY-32797', 'Dublin'),\n", " ('Paul Nicholson', '08-LD-12240', 'Wexford'),\n", " ('Donna Mason', '18-WW-11514', 'Longford'),\n", " ('Dana Wade', '03-L-40377', 'Mayo'),\n", " ('Jenny Juarez', '15-G-37225', 'Longford'),\n", " ('Emily Alvarado', '14-CN-41515', 'Longford'),\n", " ('Robert Fields', '09-LS-131', 'Louth'),\n", " ('David Cox', '12-LS-47102', 'Leitrim'),\n", " ('Alan Cabrera', '15-WX-8189', 'Leitrim'),\n", " ('Donna Mason', '13-CW-21688', 'Longford'),\n", " ('John Davis', '15-DL-3247', 'Dublin'),\n", " ('Raymond Perkins', '02-D-22267', 'Clare'),\n", " ('Robert Acevedo', '01-LS-33323', 'Meath'),\n", " ('Peter Vaughn DDS', '10-WH-9955', 'Cork'),\n", " ('Joseph Griffith', '03-MO-4365', 'Wicklow'),\n", " ('Joseph Griffith', '04-LD-23688', 'Wicklow'),\n", " ('Alan Williams', '13-G-16885', 'Galway'),\n", " ('Jenny Juarez', '18-KE-36389', 'Longford'),\n", " ('Melissa Lowe', '01-T-15866', 'Westmeath'),\n", " ('Christopher Miller', '08-KE-16056', 'Kerry'),\n", " ('Kayla Rodriguez DVM', '13-G-24475', 'Clare'),\n", " ('Emily Cooper', '03-MO-25665', 'Kildare'),\n", " ('Stephanie Yates', '18-T-2425', 'Meath'),\n", " ('Elizabeth Harper', '04-WW-24305', 'Donegal'),\n", " ('Shannon Oneal', '13-OY-23701', 'Sligo'),\n", " ('David Matthews', '08-MO-46007', 'Leitrim'),\n", " ('Robert Price', '00-L-47267', 'Dublin'),\n", " ('Emily Cooper', '08-KK-47849', 'Kildare'),\n", " ('Elizabeth Harper', '16-MN-41115', 'Donegal'),\n", " ('Dana Wade', '02-DL-7526', 'Mayo'),\n", " ('Melanie White', '01-G-15863', 'Carlow'),\n", " ('Elizabeth Harper', '14-SO-6402', 'Donegal'),\n", " ('Lori Harmon', '02-CN-7196', 'Carlow'),\n", " ('Christopher Mcmahon', '01-CW-35670', 'Limerick'),\n", " ('Sandra Knight', '16-T-45794', 'Offaly'),\n", " ('Anna Henry', '03-KK-1616', 'Carlow'),\n", " ('Jennifer Reeves', '08-WX-43305', 'Offaly'),\n", " ('Mrs. Sheila Wilkerson', '15-W-31836', 'Tipperary'),\n", " ('Susan Cummings', '03-KE-1400', 'Cork'),\n", " ('Jared Nguyen', '08-WW-22857', 'Cavan'),\n", " ('Elizabeth Harper', '15-L-48040', 'Donegal'),\n", " ('Stephanie Yates', '05-CN-49186', 'Meath'),\n", " ('Tracey Olson', '18-T-43669', 'Kilkenny'),\n", " ('John Davis', '05-WX-40194', 'Dublin'),\n", " ('Anna Henry', '08-LH-30886', 'Carlow'),\n", " ('Melanie White', '07-G-36331', 'Carlow'),\n", " ('Leonard Chen', '06-WW-48865', 'Galway'),\n", " ('Leonard Brown', '16-MO-40801', 'Sligo'),\n", " ('George Fitzgerald', '15-L-37732', 'Carlow'),\n", " ('Gail Jones', '10-G-21752', 'Waterford'),\n", " ('Susan Cummings', '08-C-34297', 'Cork'),\n", " ('Jacob Moore', '17-SO-23443', 'Longford'),\n", " ('Dana Wade', '05-CN-5924', 'Mayo'),\n", " ('David Cox', '05-W-22770', 'Leitrim'),\n", " ('Joshua Perez', '10-LH-34050', 'Galway'),\n", " ('Robert Fields', '16-LS-26245', 'Louth'),\n", " ('Hannah Collier', '05-D-30917', 'Leitrim'),\n", " ('Dana Wade', '07-G-48955', 'Mayo'),\n", " ('Diane Hunt', '13-G-48846', 'Westmeath'),\n", " ('Megan Clarke', '05-L-42386', 'Kildare'),\n", " ('Richard Foley', '08-T-12971', 'Offaly'),\n", " ('Carrie Sullivan', '18-WH-6082', 'Galway'),\n", " ('Daniel Smith', '12-MO-30235', 'Limerick'),\n", " ('John Davis', '16-T-22243', 'Dublin'),\n", " ('Jeff Stevens', '03-L-37130', 'Dublin'),\n", " ('Devin Shaw', '12-MO-18353', 'Wexford'),\n", " ('Robert Fields', '11-MN-11186', 'Louth'),\n", " ('Robert Price', '05-WX-40062', 'Dublin'),\n", " ('Melissa Lowe', '04-D-38409', 'Westmeath'),\n", " ('William Hall', '16-CE-29807', 'Kerry'),\n", " ('Joseph Griffith', '15-D-4632', 'Wicklow'),\n", " ('Joshua Perez', '14-LM-31240', 'Galway'),\n", " ('David Cox', '15-LH-20280', 'Leitrim'),\n", " ('Jeff Stevens', '04-L-14265', 'Dublin'),\n", " ('Sandra Knight', '05-KK-13066', 'Offaly'),\n", " ('Jordan Velasquez', '02-MN-14407', 'Galway'),\n", " ('Jared Nguyen', '11-CE-42446', 'Cavan'),\n", " ('Melissa Lowe', '16-W-29168', 'Westmeath'),\n", " ('Katherine Dalton', '03-G-19542', 'Kildare'),\n", " ('Hannah Collier', '18-MO-35400', 'Leitrim'),\n", " ('Alan Williams', '11-KK-35894', 'Galway'),\n", " ('Seth Simpson', '07-G-5958', 'Westmeath')]" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c.execute(\"\"\"\n", " SELECT p.Name, c.Registration, p.Address\n", " FROM person as p\n", " JOIN car as c ON p.ID = c.OwnerId\n", " JOIN county as t ON t.Name = p.Address\n", " WHERE c.Registration NOT LIKE '%-' + t.Registration + '-%'\n", "\"\"\")\n", "c.fetchall()" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [], "source": [ "conn.close()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "**[w3schools SQL Tutorial](https://www.w3schools.com/sql/default.asp)**\n", "\n", "*[https://www.w3schools.com/sql/default.asp](https://www.w3schools.com/sql/default.asp)*\n", "\n", "An e online sim" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "\n", "## End" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.6" } }, "nbformat": 4, "nbformat_minor": 2 }