MySQL_Exercise_01_Looking_at_Your_Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Copyright Jana Schaich Borg/Attribution-NonCommercial 4.0 International (CC BY-NC 4.0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# MySQL Exercise 1: Welcome to your first notebook!\n",
    "\n",
    "Database interfaces vary greatly across platforms and companies.  The interface you will be using here, called Jupyter, is a web application designed for data science teams who need to create and share documents that share live code.  We will be taking advantage of Jupyter's ability to integrate instructional text with areas that allow you to write and run SQL queries.  In this course, you will practice writing queries about the Dognition data set in these Jupyter notebooks as I give you step-by-step instructions through written text.  Then once you are comfortable with the query syntax, you will practice writing queries about the Dillard's data set in Teradata Viewpoint's more traditional SQL interface, called SQL scratchpad. Your assessments each week will be based on the exercises you complete using the Dillard's dataset.\n",
    "\n",
    "Jupyter runs in a language called Python, so some of the commands you will run in these MySQL exercises will require incorporating small amounts of Python code, along with the MySQL query itself.  Python is a very popular programming language with many statistical and visualization libraries, so you will likely encounter it in other business analysis settings.  Since many data analysis projects do not use Python, however, I will point out to you what parts of the commands are specific to Python interfaces. \n",
    "\n",
    "## The first thing you should do every time you start working with a database: load the SQL library\n",
    "\n",
    "Since Jupyter is run through Python, the first thing you need to do to start practicing SQL queries is load the SQL library.  To do this, type the following line of code into the empty cell below:\n",
    "\n",
    "```python\n",
    "%load_ext sql\n",
    "```\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "%load_ext sql"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "The \"%\" in this line of code is syntax for Python, not SQL.  The \"cell\" I am referring to is the empty box area beside the \"In [  ]:\" you see on the left side of the screen.\n",
    "\n",
    "Once you've entered the line of code, press the \"run\" button on the Jupyter toolbar that looks like an arrow.  It's located under “cell” in the drop-down menu bar, and next to the stop button (the solid square).  The run button is outlined in red in this picture:\n",
    "\n",
    "![alt text](https://duke.box.com/shared/static/u9chww13kim30t5p6ndh404d9ap6auwf.jpg)\n",
    "\n",
    "**TIP: Whenever instructions say “run” or \"execute\" a command in future exercises, type the appropriate code into the empty cell and execute it by pressing this same button with the arrow.**\n",
    "\n",
    "When the library has loaded, you will see a number between the brackets that preceed the line of code you executed: \n",
    "\n",
    "For example, it might look like this: \n",
    "\n",
    "```\n",
    "In [2]:\n",
    "```\n",
    "    \n",
    "\n",
    "## The second thing you must do every time you want to start working with a database: connect to the database you need to use.\n",
    "\n",
    "Now that the SQL library is loaded, we need to connect to a database.  The following command will log you into the MySQL server at mysqlserver as the user 'studentuser' and will select the database named 'dognitiondb' :\n",
    "\n",
    "```python\n",
    "mysql://studentuser:studentpw@mysqlserver/dognitiondb\n",
    "```\n",
    "\n",
    "However, to execute this command using SQL language instead of Python, you will need to begin the line of code with:\n",
    "\n",
    "```python\n",
    "%sql\n",
    "```\n",
    "\n",
    "Thus, the complete line of code is:\n",
    "\n",
    "```python\n",
    "%sql mysql://studentuser:studentpw@mysqlserver/dognitiondb\n",
    "```\n",
    "\n",
    "Connect to the database by typing this command into the cell below, and running it (note: you can copy and paste the command from above rather than typing it, if you choose):\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Connected: studentuser@dognitiondb'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql mysql://studentuser:studentpw@mysqlserver/dognitiondb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<mark>***Every time you run a line of SQL code in Jupyter, you will need to preface the line with \"%sql\".  Remember to do this, even though I will not explicitly instruct you to do so for the rest of the exercises in this course.***</mark>\n",
    "\n",
    "Once you are connected, the output cell (which reads \"Out\" followed by brackets) will read: \"Connected:studentuser@dognitiondb\".  To make this the default database for our queries, run this \"USE\" command:\n",
    "\n",
    "```python\n",
    "%sql USE dognitiondb\n",
    "```\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql USE dognitiondb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You are now ready to run queries in the Dognition database!\n",
    "\n",
    "\n",
    "## The third thing you should do every time you start working with a new database: get to know your data\n",
    "\n",
    "The data sets you will be working with in business settings will be big.  REALLY big.  If you just start making queries without knowing what you are pulling out, you could hang up your servers or be staring at your computer for hours before you get an output.  Therefore, even if you are given an ER diagram or relational schema like we learned about in the first week of the course, before you start querying I strongly recommend that you (1) confirm how many tables each database has, and (2) identify the fields contained in each table of the database.  To determine how many tables each database has, use the SHOW command:\n",
    "\n",
    "```mySQL\n",
    "SHOW tables\n",
    "```\n",
    "\n",
    "**Try it yourself (TIP: if you get an error message, it's probably because you forgot to start the query with \"%sql\"):**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Tables_in_dognitiondb</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>complete_tests</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dogs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>exam_answers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>reviews</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>site_activities</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>users</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('complete_tests',),\n",
       " ('dogs',),\n",
       " ('exam_answers',),\n",
       " ('reviews',),\n",
       " ('site_activities',),\n",
       " ('users',)]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SHOW tables"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The output that appears above should show you there are six tables in the Dognition database.  To determine what columns or fields (we will use those terms interchangeably in this course) are in each table, you can use the SHOW command again, but this time (1) you have to clarify that you want to see columns instead of tables, and (2) you have to specify from which table you want to examine the columns. \n",
    "\n",
    "The syntax, which sounds very similar to what you would actually say in the spoken English language, looks like this:\n",
    "\n",
    "```mySQL\n",
    "SHOW columns FROM (enter table name here)\n",
    "```\n",
    "or if you have multiple databases loaded:\n",
    "```mySQL\n",
    "SHOW columns FROM (enter table name here) FROM (enter database name here)\n",
    "```\n",
    "or\n",
    "```mySQL\n",
    "SHOW columns FROM databasename.tablename \n",
    "```\n",
    "<mark> Whenever you have multiple databases loaded, you will need to specify which database a table comes from using one of the syntax options described above.</mark>\n",
    "\n",
    "As I said in the earlier \"Introduction to Query Syntax\" video, it makes it easier to read and troubleshoot your queries if you always write SQL keywords in UPPERCASE format and write your table and field names in their native format.  We will only use the most important SQL keywords in this course, but a full list can be found here:\n",
    "\n",
    "https://dev.mysql.com/doc/refman/5.5/en/keywords.html\n",
    "\n",
    "\n",
    "**Question 1: How many columns does the \"dogs\" table have?  Enter the appropriate query below to find out:**\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "21 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>gender</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>birthday</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>breed</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>weight</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_fixed</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dna_tested</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>created_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>updated_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dimension</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>exclude</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>breed_type</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>breed_group</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>user_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>total_tests_completed</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>mean_iti_days</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>mean_iti_minutes</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>median_iti_days</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>median_iti_minutes</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>time_diff_between_first_and_last_game_days</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>time_diff_between_first_and_last_game_minutes</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('gender', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('birthday', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('breed', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('weight', 'int(11)', 'YES', '', None, ''),\n",
       " ('dog_fixed', 'tinyint(1)', 'YES', '', None, ''),\n",
       " ('dna_tested', 'tinyint(1)', 'YES', '', None, ''),\n",
       " ('created_at', 'datetime', 'NO', '', None, ''),\n",
       " ('updated_at', 'datetime', 'NO', '', None, ''),\n",
       " ('dimension', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('exclude', 'tinyint(1)', 'YES', '', None, ''),\n",
       " ('breed_type', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('breed_group', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('dog_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('user_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('total_tests_completed', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('mean_iti_days', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('mean_iti_minutes', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('median_iti_days', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('median_iti_minutes', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('time_diff_between_first_and_last_game_days', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('time_diff_between_first_and_last_game_minutes', 'varchar(255)', 'YES', '', None, '')]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SHOW columns from dogs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You should have determined that the \"dogs\" table has 21 columns.  \n",
    "\n",
    "An alternate way to learn the same information would be to use the DESCRIBE function.  The syntax is:\n",
    "\n",
    "```mySQL\n",
    "DESCRIBE tablename\n",
    "```\n",
    "\n",
    "**Question 2: Try using the DESCRIBE function to learn how many columns are in the \"reviews\" table:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>rating</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>created_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>updated_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>user_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>subcategory_name</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>test_name</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('rating', 'int(11)', 'YES', '', None, ''),\n",
       " ('created_at', 'datetime', 'NO', '', None, ''),\n",
       " ('updated_at', 'datetime', 'NO', '', None, ''),\n",
       " ('user_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('dog_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('subcategory_name', 'varchar(60)', 'YES', '', None, ''),\n",
       " ('test_name', 'varchar(60)', 'YES', '', None, '')]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql DESCRIBE reviews"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You should have determined that there are 7 columns in the \"reviews\" table.  \n",
    "\n",
    "The SHOW and DESCRIBE functions give a lot more information about the table than just how many columns, or fields, there are.  Indeed, the first column of the output shows the title of each field in the table.  The column next to that describes what type of data are stored in that column.  There are 3 main types of data in MySQL: text, number, and datetime.  There are many subtypes of data within these three general categories, as described here:\n",
    "\n",
    "http://support.hostgator.com/articles/specialized-help/technical/phpmyadmin/mysql-variable-types\n",
    "\n",
    "The next column in the SHOW/DESCRIBE output indicates whether null values can be stored in the field in the table.  The \"Key\" column of the output provides the following information about each field of data in the table being described (see https://dev.mysql.com/doc/refman/5.6/en/show-columns.html for more information): \n",
    "\n",
    "+ Empty: the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index.\n",
    "+ PRI: the column is a PRIMARY KEY or is one of the columns in a multiple-column PRIMARY KEY.\n",
    "+ UNI: the column is the first column of a UNIQUE index. \n",
    "+ MUL: the column is the first column of a nonunique index in which multiple occurrences of a given value are permitted within the column.\n",
    "\n",
    "The \"Default\" field of the output indicates the default value that is assigned to the field. The \"Extra\" field contains any additional information that is available about a given field in that table. \n",
    "\n",
    "**Questions 3-6: In the cells below, examine the fields in the other 4 tables of the Dognition database:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "16 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>sign_in_count</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>0</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>created_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>updated_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>max_dogs</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>0</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>membership_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>subscribed</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>0</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>exclude</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>free_start_user</td>\n",
       "        <td>tinyint(1)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>last_active_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>membership_type</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>user_guid</td>\n",
       "        <td>text</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>city</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>state</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>zip</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>country</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>utc_correction</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('sign_in_count', 'int(11)', 'YES', '', '0', ''),\n",
       " ('created_at', 'datetime', 'NO', '', None, ''),\n",
       " ('updated_at', 'datetime', 'NO', '', None, ''),\n",
       " ('max_dogs', 'int(11)', 'YES', '', '0', ''),\n",
       " ('membership_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('subscribed', 'tinyint(1)', 'YES', '', '0', ''),\n",
       " ('exclude', 'tinyint(1)', 'YES', '', None, ''),\n",
       " ('free_start_user', 'tinyint(1)', 'YES', '', None, ''),\n",
       " ('last_active_at', 'datetime', 'YES', '', None, ''),\n",
       " ('membership_type', 'int(11)', 'YES', '', None, ''),\n",
       " ('user_guid', 'text', 'YES', 'MUL', None, ''),\n",
       " ('city', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('state', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('zip', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('country', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('utc_correction', 'varchar(255)', 'YES', '', None, '')]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql DESCRIBE users"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "11 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>activity_type</td>\n",
       "        <td>varchar(150)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>description</td>\n",
       "        <td>text</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>membership_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>category_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>script_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>created_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>updated_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>user_guid</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>script_detail_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>test_name</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_guid</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('activity_type', 'varchar(150)', 'YES', 'MUL', None, ''),\n",
       " ('description', 'text', 'YES', '', None, ''),\n",
       " ('membership_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('category_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('script_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('created_at', 'datetime', 'NO', '', None, ''),\n",
       " ('updated_at', 'datetime', 'NO', '', None, ''),\n",
       " ('user_guid', 'varchar(255)', 'YES', 'MUL', None, ''),\n",
       " ('script_detail_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('test_name', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('dog_guid', 'varchar(255)', 'YES', 'MUL', None, '')]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql DESCRIBE site_activities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "8 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>script_detail_id</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>subcategory_name</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>test_name</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>step_type</td>\n",
       "        <td>varchar(255)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>start_time</td>\n",
       "        <td>datetime</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>end_time</td>\n",
       "        <td>datetime</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>loop_number</td>\n",
       "        <td>int(11)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('script_detail_id', 'int(11)', 'YES', '', None, ''),\n",
       " ('subcategory_name', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('test_name', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('step_type', 'varchar(255)', 'YES', '', None, ''),\n",
       " ('start_time', 'datetime', 'YES', '', None, ''),\n",
       " ('end_time', 'datetime', 'YES', '', None, ''),\n",
       " ('loop_number', 'int(11)', 'YES', '', None, ''),\n",
       " ('dog_guid', 'varchar(60)', 'YES', '', None, '')]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql DESCRIBE exam_answers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Field</th>\n",
       "        <th>Type</th>\n",
       "        <th>Null</th>\n",
       "        <th>Key</th>\n",
       "        <th>Default</th>\n",
       "        <th>Extra</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>created_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>updated_at</td>\n",
       "        <td>datetime</td>\n",
       "        <td>NO</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>user_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>dog_guid</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td>MUL</td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>test_name</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>subcategory_name</td>\n",
       "        <td>varchar(60)</td>\n",
       "        <td>YES</td>\n",
       "        <td></td>\n",
       "        <td>None</td>\n",
       "        <td></td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('created_at', 'datetime', 'NO', '', None, ''),\n",
       " ('updated_at', 'datetime', 'NO', '', None, ''),\n",
       " ('user_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('dog_guid', 'varchar(60)', 'YES', 'MUL', None, ''),\n",
       " ('test_name', 'varchar(60)', 'YES', '', None, ''),\n",
       " ('subcategory_name', 'varchar(60)', 'YES', '', None, '')]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql DESCRIBE complete_tests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As you examine the fields in each table, you will notice that none of the Dognition tables have primary keys declared.  However, take note of which fields say \"MUL\" in the \"Key\" column of the DESCRIBE output, because these columns can still be used to link tables together.  An important thing to keep in mind, though, is that because these linking columns were not configured as primary keys, it is possible the linking fields contain NULL values or duplicate rows.\n",
    "    \n",
    "If you do not have a ER diagram or relational schema of the Dognition database yet, consider making one at this point, because you will need to refer back to table and column names constantly throughout designing your queries  (if you don't remember what primary keys, secondary keys, ER diagrams, or relational schemas are, review the material discussed in the first week of this course).  Some database interfaces do provide notes or visual representations about the information in each table for easy reference, but since the Jupyter interface does not provide this, take your own notes and make your own diagrams, and keep them handy.  As you will see, these diagrams and notes will save you a lot of time when you design your queries to pull data.\n",
    "\n",
    "\n",
    "## Using SELECT to look at your raw data\n",
    "\n",
    "Once you have an idea of what is in your tables look like and how they might interact, it's a good idea to look at some of the raw data itself so that you are aware of any anomalies that could pose problems for your analysis or interpretations.  To do that, we will use arguably the most important SQL statement for analysts: the SELECT statement.\n",
    "\n",
    "SELECT is used anytime you want to retrieve data from a table.  In order to retrieve that data, you always have to provide at least two pieces of information: \n",
    "   \n",
    "    (1) what you want to select, and      \n",
    "    (2) from where you want to select it.  \n",
    "    \n",
    "I recommend that you always format your SQL code to ensure that these two pieces of information are on separate lines, so they are easy to identify quickly by eye.  \n",
    "\n",
    "The skeleton of a SELECT statement looks like this:\n",
    "\n",
    "```mySQL\n",
    "SELECT\n",
    "FROM\n",
    "```\n",
    "\n",
    "To fill in the statement, you indicate the column names you are interested in after \"SELECT\" and the table name (and database name, if you have multiple databases loaded) you are drawing the information from after \"FROM.\"  So in order to look at the breeds in the dogs table, you would execute the following command:\n",
    "\n",
    "```mySQL\n",
    "SELECT breed\n",
    "FROM dogs;\n",
    "```\n",
    "\n",
    "Remember:\n",
    "+ SQL syntax and keywords are case insensitive.  I recommend that you always enter SQL keywords in upper case and table or column names in either lower case or their native format to make it easy to read and troubleshoot your code, but it is not a requirement to do so.  Table or column names are often case insensitive as well, but defaults may vary across database platforms so it's always a good idea to check.\n",
    "+ Table or column names with spaces in them need to be surrounded by quotation marks in SQL.  MySQL accepts both double and single quotation marks, but some database systems only accept single quotation marks.  In all database systems, if a table or column name contains an SQL keyword, the name must be enclosed in backticks instead of quotation marks.\n",
    "> ` 'the marks that surrounds this phrase are single quotation marks' `     \n",
    "> ` \"the marks that surrounds this phrase are double quotation marks\" `     \n",
    "> `` `the marks that surround this phrase are backticks` ``\n",
    "+ The semi-colon at the end of a query is only required when you have multiple separate queries saved in the same text file or editor.  That said, I recommend that you make it a habit to always include a semi-colon at the end of your queries.  \n",
    "\n",
    "<mark>An important note for executing queries in Jupyter: in order to tell Python that you want to execute SQL language on multiple lines, you must include two percent signs in front of the SQL prefix instead of one.</mark>  Therefore, to execute the above query, you should enter:\n",
    "\n",
    "```mySQL\n",
    "%%sql\n",
    "SELECT breed\n",
    "FROM dogs;\n",
    "```\n",
    "\n",
    "When Jupyter is busy executing a query, you will see an asterisk in the brackets next to the output field:\n",
    "\n",
    "```\n",
    "Out [*]\n",
    "```\n",
    "\n",
    "When the query is completed, you will see a number in the brackets next to the output field.\n",
    "\n",
    "```\n",
    "Out [5]\n",
    "```\n",
    "\n",
    "**Try it yourself:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "35050 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>breed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Pembroke Welsh Corgi Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Vizsla</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chesapeake Bay Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bouvier des Flandres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mudi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Parson Russell Terrier-Beagle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Tervuren</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua-Dachshund Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Finnish Spitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rottweiler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Brussels Griffon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Doberman Pinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Cocker Spaniel-Cocker Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rottweiler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel-Bichon Frise Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bedlington Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Irish Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Irish Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Irish Red and White Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Cocker Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle-Schipperke Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier-Chihuahua Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle-Cavalier King Charles Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rottweiler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Lhasa Apso-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Neapolitan Mastiff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rat Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Collie-Shetland Sheepdog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Eskimo Dog-Papillon Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Papillon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pomeranian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Belgian Tervuren Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Yorkshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shiba Inu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rat Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Greyhound Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Parson Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>West Highland White Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Miniature Schnauzer Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Vizsla</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Silky Terrier-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier-Miniature Pinscher Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Flat-Coated Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Staffordshire Bull Terrier-Bulldog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Kooikerhondje</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Staffordshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cardigan Welsh Corgi-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Doberman Pinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Doberman Pinscher-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Canaan Dog- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier-Pug Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Parson Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua-Dachshund Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Australian Shepherd Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Italian Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Leonberger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boykin Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Soft Coated Wheaten Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Brittany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Chinese Shar-Pei Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Lhasa Apso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Eskimo Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Keeshond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bull Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Soft Coated Wheaten Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu-Maltese Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chesapeake Bay Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua-Miniature Pinscher Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Shih Tzu Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund-Miniature Pinscher Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature American Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Parson Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Affenpinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Keeshond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Cane Corso Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bichon Frise-Shih Tzu Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pointer-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Basenji Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi-Russell Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog-Beagle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Maltese Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Great Dane-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Brittany-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Scottish Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>West Highland White Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Cardigan Welsh Corgi Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bearded Collie-Tibetan Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature American Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Great Dane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Icelandic Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Chihuahua Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier-Bichon Frise Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cairn Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Sheepdog- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Old English Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>West Highland White Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier-American Staffordshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier-American Staffordshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Danish-Swedish Farmdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cardigan Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bichon Frise-Cavalier King Charles Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback-Boxer Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Cavalier King Charles Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Cavalier King Charles Spaniel Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Rottweiler Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pomeranian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chow Chow-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Beagle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Staffordshire Terrier-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Affenpinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Scottish Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Coton de Tulear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cardigan Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Water Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier-Chihuahua Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mastiff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shiba Inu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Belgian Tervuren Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Staffordshire Terrier-Australian Shepherd Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pekingese-Dachshund Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Siberian Husky Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rat Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rottweiler- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Maltese Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cairn Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky-Australian Shepherd Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Whippet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>West Highland White Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier-Bulldog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Dalmatian Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Welsh Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Old English Sheepdog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Staffordshire Bull Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Soft Coated Wheaten Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Staffordshire Bull Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bichon Frise-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer-Catahoula Leopard Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Alaskan Malamute-Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Doberman Pinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Coton de Tulear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever-Newfoundland Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Staffordshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer-American Staffordshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Norfolk Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Norfolk Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Rottweiler Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Staffordshire Bull Terrier-Great Dane Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Wire Fox Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Samoyed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Coton de Tulear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Maltese Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Yorkshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pekingese-Shih Tzu Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Staffordshire Bull Terrier-Miniature Schnauzer Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Puggle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cockapoo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dalmatian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boston Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pomeranian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Whippet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Wire Fox Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Wire Fox Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Smooth Fox Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Wire Fox Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bearded Collie-Beagle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Great Dane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Brussels Griffon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Irish Setter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Puggle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Dachshund Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Schnauzer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Chihuahua Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Coton de Tulear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Papillon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mastiff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Polish Lowland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Miniature Pinscher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Springer Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Eskimo Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Soft Coated Wheaten Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chinese Crested-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Catahoula Leopard Dog-Rottweiler Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Tervuren</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Tervuren</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Nova Scotia Duck Tolling Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>West Highland White Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle-Shih Tzu Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer-Border Collie Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Great Dane-Irish Wolfhound Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pyrenean Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pyrenean Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chinese Shar-Pei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mastiff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Lhasa Apso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dogue de Bordeaux-Boxer Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Greyhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Akita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Staffordshire Terrier-Catahoula Leopard Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Scottish Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu-Pekingese Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rat Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund-Beagle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Silky Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Scottish Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>-German Shepherd Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Keeshond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shorthaired Pointer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Coton de Tulear</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>American Pit Bull Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bernese Mountain Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Chow Chow Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Weimaraner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Australian Shepherd Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Beagle-Australian Cattle Dog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pembroke Welsh Corgi-Great Pyrenees Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd-Pembroke Welsh Corgi Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>French Bulldog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chesapeake Bay Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Doodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Maltese-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Havanese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Shepherd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Afghan Hound-Golden Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Dachshund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shorkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Field Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cavalier King Charles Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chihuahua-American Staffordshire Terrier Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Newfoundland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Yorkshire Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Australian Cattle Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>English Cocker Spaniel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bluetick Coonhound</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug-Miniature Pinscher Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Whippet-Chinese Shar-Pei Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer-Bulldog Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labradoodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Papillon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Poodle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Portuguese Water Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Vizsla- Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chow Chow-Labrador Retriever Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rat Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rhodesian Ridgeback-Boxer Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Whippet Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Russell Terrier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Other</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Belgian Malinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Border Collie-Pembroke Welsh Corgi Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "</table>\n",
       "<span style=\"font-style:italic;text-align:center;\">35050 rows, truncated to displaylimit of 1000</span>"
      ],
      "text/plain": [
       "[('Labrador Retriever',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Shih Tzu',),\n",
       " ('Siberian Husky',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Shih Tzu-Poodle Mix',),\n",
       " ('German Shepherd Dog-Pembroke Welsh Corgi Mix',),\n",
       " ('Vizsla',),\n",
       " ('Pug',),\n",
       " ('Boxer',),\n",
       " ('German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix',),\n",
       " ('Beagle',),\n",
       " ('Beagle',),\n",
       " ('Beagle',),\n",
       " ('Mixed',),\n",
       " ('Chesapeake Bay Retriever',),\n",
       " ('Border Collie',),\n",
       " ('Belgian Malinois',),\n",
       " ('Australian Shepherd-German Shepherd Dog Mix',),\n",
       " ('Poodle',),\n",
       " ('Poodle',),\n",
       " ('Golden Doodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('German Shepherd Dog',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Weimaraner',),\n",
       " ('Mixed',),\n",
       " ('Bouvier des Flandres',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Beagle',),\n",
       " ('Mudi',),\n",
       " ('Parson Russell Terrier-Beagle Mix',),\n",
       " ('Dalmatian',),\n",
       " (\"I Don't Know\",),\n",
       " ('Border Collie-Labrador Retriever Mix',),\n",
       " ('Belgian Tervuren',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Shih Tzu',),\n",
       " ('Australian Terrier',),\n",
       " ('Shih Tzu',),\n",
       " ('Golden Retriever',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Chihuahua- Mix',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Mixed',),\n",
       " ('Chihuahua-Dachshund Mix',),\n",
       " ('Finnish Spitz',),\n",
       " ('Siberian Husky',),\n",
       " ('Rottweiler',),\n",
       " ('Pembroke Welsh Corgi',),\n",
       " ('Brussels Griffon',),\n",
       " ('Mixed',),\n",
       " ('French Bulldog',),\n",
       " ('French Bulldog',),\n",
       " ('Shih Tzu',),\n",
       " ('Doberman Pinscher',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Pembroke Welsh Corgi',),\n",
       " ('English Cocker Spaniel-Cocker Spaniel Mix',),\n",
       " ('Rottweiler',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Cavalier King Charles Spaniel-Bichon Frise Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Bedlington Terrier',),\n",
       " ('Labrador Retriever',),\n",
       " ('Russell Terrier',),\n",
       " ('Poodle',),\n",
       " ('Irish Setter',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Irish Setter',),\n",
       " ('Poodle',),\n",
       " ('Irish Red and White Setter',),\n",
       " ('Poodle-Cocker Spaniel Mix',),\n",
       " ('American Pit Bull Terrier',),\n",
       " ('Golden Retriever',),\n",
       " ('Beagle-Schipperke Mix',),\n",
       " ('Greyhound',),\n",
       " ('Labrador Retriever-Golden Retriever Mix',),\n",
       " ('Labrador Retriever-Golden Retriever Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Boston Terrier-Chihuahua Mix',),\n",
       " ('American Pit Bull Terrier',),\n",
       " ('Mixed',),\n",
       " ('Beagle-Cavalier King Charles Spaniel Mix',),\n",
       " ('Boxer',),\n",
       " ('Pug',),\n",
       " ('French Bulldog',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Labradoodle',),\n",
       " ('Mixed',),\n",
       " ('Pembroke Welsh Corgi',),\n",
       " ('Golden Retriever',),\n",
       " ('Cocker Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Rottweiler',),\n",
       " ('Labrador Retriever-Border Collie Mix',),\n",
       " ('Lhasa Apso-Poodle Mix',),\n",
       " ('Labradoodle',),\n",
       " ('English Springer Spaniel',),\n",
       " ('English Springer Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Neapolitan Mastiff',),\n",
       " ('Rat Terrier',),\n",
       " ('Border Terrier',),\n",
       " ('Collie-Shetland Sheepdog Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Dachshund',),\n",
       " ('Dachshund',),\n",
       " ('Golden Retriever-Collie Mix',),\n",
       " ('Beagle',),\n",
       " ('Labrador Retriever',),\n",
       " ('American Eskimo Dog-Papillon Mix',),\n",
       " ('Papillon',),\n",
       " ('Pomeranian',),\n",
       " ('German Shepherd Dog-Belgian Tervuren Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Maltese-Yorkshire Terrier Mix',),\n",
       " ('Australian Shepherd',),\n",
       " ('Shiba Inu',),\n",
       " ('Rat Terrier',),\n",
       " ('Poodle',),\n",
       " ('Border Collie-Greyhound Mix',),\n",
       " ('Poodle',),\n",
       " ('Labradoodle',),\n",
       " ('Mixed',),\n",
       " ('Maltese-Poodle Mix',),\n",
       " ('Siberian Husky-German Shepherd Dog Mix',),\n",
       " ('Chihuahua',),\n",
       " ('Golden Retriever-German Shepherd Dog Mix',),\n",
       " ('Parson Russell Terrier',),\n",
       " ('Rhodesian Ridgeback',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Chihuahua',),\n",
       " ('West Highland White Terrier',),\n",
       " ('Poodle-Miniature Schnauzer Mix',),\n",
       " ('Maltese-Poodle Mix',),\n",
       " ('Yorkshire Terrier-Poodle Mix',),\n",
       " ('Vizsla',),\n",
       " ('Golden Retriever',),\n",
       " ('Labradoodle',),\n",
       " ('Silky Terrier-Poodle Mix',),\n",
       " ('Mixed',),\n",
       " ('Russell Terrier-Miniature Pinscher Mix',),\n",
       " ('Mixed',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Yorkshire Terrier',),\n",
       " ('Australian Cattle Dog- Mix',),\n",
       " ('Mixed',),\n",
       " ('Flat-Coated Retriever',),\n",
       " ('Staffordshire Bull Terrier-Bulldog Mix',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Kooikerhondje',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Labrador Retriever-Golden Retriever Mix',),\n",
       " ('German Shepherd Dog-Border Collie Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Labradoodle',),\n",
       " ('Shih Tzu',),\n",
       " ('American Staffordshire Terrier',),\n",
       " ('Bulldog',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Beagle',),\n",
       " ('Beagle',),\n",
       " ('Cardigan Welsh Corgi-German Shepherd Dog Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Doberman Pinscher',),\n",
       " ('Doberman Pinscher-German Shepherd Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Canaan Dog- Mix',),\n",
       " ('Beagle',),\n",
       " ('Rhodesian Ridgeback',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Russell Terrier-Pug Mix',),\n",
       " ('Mixed',),\n",
       " ('Australian Cattle Dog-Border Collie Mix',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Shih Tzu',),\n",
       " ('English Cocker Spaniel',),\n",
       " ('Australian Shepherd',),\n",
       " ('Parson Russell Terrier',),\n",
       " ('Boxer',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Chihuahua-Dachshund Mix',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('Border Collie-Australian Shepherd Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Australian Shepherd-Border Collie Mix',),\n",
       " ('Mixed',),\n",
       " ('Poodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('French Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Italian Greyhound',),\n",
       " ('Weimaraner',),\n",
       " ('Leonberger',),\n",
       " ('Poodle',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Boykin Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Soft Coated Wheaten Terrier',),\n",
       " ('Poodle',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Bulldog',),\n",
       " ('Golden Retriever',),\n",
       " ('Boston Terrier',),\n",
       " ('Shih Tzu',),\n",
       " ('Brittany',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Golden Retriever-Labrador Retriever Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever-Labrador Retriever Mix',),\n",
       " ('Mixed',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('Labrador Retriever-Chinese Shar-Pei Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('Australian Shepherd',),\n",
       " ('Mixed',),\n",
       " ('Siberian Husky',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Lhasa Apso',),\n",
       " ('Australian Shepherd',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('American Eskimo Dog',),\n",
       " ('Boxer',),\n",
       " ('Keeshond',),\n",
       " ('Bull Terrier',),\n",
       " ('Soft Coated Wheaten Terrier',),\n",
       " ('Boston Terrier',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Poodle',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Shih Tzu-Maltese Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Chesapeake Bay Retriever',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Cocker Spaniel',),\n",
       " ('Labrador Retriever',),\n",
       " ('Maltese',),\n",
       " ('Mixed',),\n",
       " ('Cockapoo',),\n",
       " ('Chihuahua-Miniature Pinscher Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Shih Tzu',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('Maltese-Poodle Mix',),\n",
       " ('Maltese-Shih Tzu Mix',),\n",
       " ('Mixed',),\n",
       " ('Boxer',),\n",
       " ('Dachshund-Miniature Pinscher Mix',),\n",
       " ('Mixed',),\n",
       " ('Miniature American Shepherd',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Parson Russell Terrier',),\n",
       " ('Border Collie',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Labrador Retriever-Australian Cattle Dog Mix',),\n",
       " ('Poodle',),\n",
       " ('Shih Tzu',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " (\"I Don't Know\",),\n",
       " ('Border Collie',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Chihuahua',),\n",
       " ('Australian Shepherd',),\n",
       " ('Poodle',),\n",
       " ('Affenpinscher',),\n",
       " ('Keeshond',),\n",
       " ('Chihuahua',),\n",
       " ('English Setter',),\n",
       " ('Miniature Schnauzer-Poodle Mix',),\n",
       " ('Mixed',),\n",
       " ('Havanese',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Australian Shepherd',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " ('Boxer',),\n",
       " ('Labrador Retriever-Cane Corso Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Bichon Frise-Shih Tzu Mix',),\n",
       " ('Pug',),\n",
       " ('Pointer-Labrador Retriever Mix',),\n",
       " ('Labrador Retriever-Basenji Mix',),\n",
       " ('Poodle',),\n",
       " ('Golden Retriever',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Golden Doodle',),\n",
       " ('Pembroke Welsh Corgi-Russell Terrier Mix',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Border Collie-Labrador Retriever Mix',),\n",
       " ('Mixed',),\n",
       " ('Bulldog-Beagle Mix',),\n",
       " ('Border Collie',),\n",
       " ('Bulldog',),\n",
       " ('Mixed',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('Mixed',),\n",
       " ('Australian Shepherd',),\n",
       " ('English Cocker Spaniel',),\n",
       " ('Golden Retriever',),\n",
       " ('Poodle-Maltese Mix',),\n",
       " ('Great Dane-Labrador Retriever Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Boxer',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Havanese',),\n",
       " ('Mixed',),\n",
       " ('Boxer',),\n",
       " ('Mixed',),\n",
       " ('Brittany-Poodle Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Scottish Terrier',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Weimaraner',),\n",
       " ('Shih Tzu',),\n",
       " ('Weimaraner',),\n",
       " ('Mixed',),\n",
       " ('West Highland White Terrier',),\n",
       " ('Labradoodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Beagle',),\n",
       " ('Labrador Retriever-Cardigan Welsh Corgi Mix',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Bearded Collie-Tibetan Terrier Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Australian Shepherd',),\n",
       " ('Beagle',),\n",
       " ('Beagle',),\n",
       " ('German Shepherd Dog',),\n",
       " (\"I Don't Know\",),\n",
       " ('Mixed',),\n",
       " ('Miniature American Shepherd',),\n",
       " ('Great Dane',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever-Labrador Retriever Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Icelandic Sheepdog',),\n",
       " ('Golden Retriever',),\n",
       " ('Dachshund',),\n",
       " ('German Shorthaired Pointer-Labrador Retriever Mix',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Pug-Chihuahua Mix',),\n",
       " ('Cockapoo',),\n",
       " ('Mixed',),\n",
       " ('Weimaraner',),\n",
       " ('Yorkshire Terrier-Bichon Frise Mix',),\n",
       " ('Cockapoo',),\n",
       " ('Border Collie',),\n",
       " ('Golden Retriever',),\n",
       " ('Cairn Terrier',),\n",
       " ('Yorkshire Terrier- Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Belgian Sheepdog- Mix',),\n",
       " ('Australian Cattle Dog-Border Collie Mix',),\n",
       " ('Old English Sheepdog',),\n",
       " ('West Highland White Terrier',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Mixed',),\n",
       " ('Boston Terrier',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('American Pit Bull Terrier-American Staffordshire Terrier Mix',),\n",
       " ('American Pit Bull Terrier-American Staffordshire Terrier Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Danish-Swedish Farmdog',),\n",
       " ('Golden Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Cardigan Welsh Corgi',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Boxer',),\n",
       " ('Boxer',),\n",
       " ('Poodle',),\n",
       " ('Mixed',),\n",
       " ('Labradoodle',),\n",
       " ('Mixed',),\n",
       " ('Labradoodle',),\n",
       " ('Mixed',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Beagle',),\n",
       " ('Bichon Frise-Cavalier King Charles Spaniel Mix',),\n",
       " ('Golden Doodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('French Bulldog',),\n",
       " ('Cockapoo',),\n",
       " ('Rhodesian Ridgeback-Boxer Mix',),\n",
       " ('Mixed',),\n",
       " ('Poodle-Cavalier King Charles Spaniel Mix',),\n",
       " ('Poodle-Cavalier King Charles Spaniel Mix',),\n",
       " ('Mixed',),\n",
       " ('Beagle-Australian Cattle Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Labrador Retriever-Rottweiler Mix',),\n",
       " ('Pomeranian',),\n",
       " ('Poodle',),\n",
       " ('Mixed',),\n",
       " ('Yorkshire Terrier',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " ('Mixed',),\n",
       " ('Dalmatian',),\n",
       " ('Chow Chow-Golden Retriever Mix',),\n",
       " ('German Shepherd Dog-Beagle Mix',),\n",
       " ('Siberian Husky',),\n",
       " ('Other',),\n",
       " ('American Staffordshire Terrier-Labrador Retriever Mix',),\n",
       " ('Yorkshire Terrier',),\n",
       " ('Cockapoo',),\n",
       " ('Affenpinscher',),\n",
       " ('Maltese',),\n",
       " ('Mixed',),\n",
       " ('Border Terrier- Mix',),\n",
       " ('Scottish Terrier',),\n",
       " ('English Setter',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Other',),\n",
       " ('Havanese',),\n",
       " ('Havanese',),\n",
       " ('Havanese',),\n",
       " ('Border Terrier',),\n",
       " ('Border Terrier',),\n",
       " ('Border Terrier',),\n",
       " ('Australian Shepherd',),\n",
       " ('Bulldog',),\n",
       " ('Coton de Tulear',),\n",
       " ('Cardigan Welsh Corgi',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Russell Terrier',),\n",
       " ('Greyhound',),\n",
       " ('American Water Spaniel',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Russell Terrier-Chihuahua Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Poodle',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Mastiff',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Mixed',),\n",
       " (\"I Don't Know\",),\n",
       " ('Shiba Inu',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " ('Beagle',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Labradoodle',),\n",
       " ('Australian Shepherd-Golden Retriever Mix',),\n",
       " ('German Shorthaired Pointer',),\n",
       " ('German Shorthaired Pointer',),\n",
       " ('German Shorthaired Pointer',),\n",
       " ('German Shorthaired Pointer',),\n",
       " ('Border Collie-Belgian Tervuren Mix',),\n",
       " ('American Staffordshire Terrier-Australian Shepherd Mix',),\n",
       " ('Pekingese-Dachshund Mix',),\n",
       " ('German Shepherd Dog-Siberian Husky Mix',),\n",
       " ('Golden Doodle',),\n",
       " ('Rat Terrier',),\n",
       " ('Chihuahua',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Rottweiler- Mix',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('Pug-Maltese Mix',),\n",
       " ('Boston Terrier',),\n",
       " ('Boston Terrier',),\n",
       " ('Labradoodle',),\n",
       " ('Border Collie',),\n",
       " ('Cairn Terrier',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('English Springer Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Maltese',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Siberian Husky-Australian Shepherd Mix',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('Chihuahua',),\n",
       " ('Whippet',),\n",
       " ('West Highland White Terrier',),\n",
       " ('Boston Terrier-Bulldog Mix',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Border Collie-Dalmatian Mix',),\n",
       " ('Other',),\n",
       " ('Cocker Spaniel',),\n",
       " ('Welsh Springer Spaniel',),\n",
       " ('Poodle-Old English Sheepdog Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Labradoodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Border Terrier',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Staffordshire Bull Terrier',),\n",
       " ('Australian Shepherd',),\n",
       " ('Havanese',),\n",
       " ('Labrador Retriever',),\n",
       " ('Soft Coated Wheaten Terrier',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Poodle',),\n",
       " ('Poodle',),\n",
       " ('Shih Tzu',),\n",
       " ('Border Collie',),\n",
       " ('Border Collie-Staffordshire Bull Terrier Mix',),\n",
       " ('Siberian Husky',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('English Springer Spaniel',),\n",
       " ('Australian Cattle Dog- Mix',),\n",
       " ('Boxer',),\n",
       " ('Other',),\n",
       " (\"I Don't Know\",),\n",
       " ('Golden Doodle',),\n",
       " ('Bichon Frise-Poodle Mix',),\n",
       " ('Mixed',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('German Shorthaired Pointer-Catahoula Leopard Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Alaskan Malamute-Collie Mix',),\n",
       " ('Mixed',),\n",
       " ('Doberman Pinscher',),\n",
       " ('Collie',),\n",
       " ('Boxer',),\n",
       " ('Weimaraner',),\n",
       " ('Boxer',),\n",
       " ('Labrador Retriever',),\n",
       " ('Poodle',),\n",
       " ('Mixed',),\n",
       " ('Coton de Tulear',),\n",
       " ('Shih Tzu',),\n",
       " ('Shih Tzu',),\n",
       " ('Golden Retriever-Newfoundland Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " ('Shih Tzu',),\n",
       " ('American Staffordshire Terrier',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Other',),\n",
       " ('Greyhound',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Border Collie',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Boxer-American Staffordshire Terrier Mix',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Cavalier King Charles Spaniel-Poodle Mix',),\n",
       " ('Other',),\n",
       " ('Shih Tzu',),\n",
       " ('Boston Terrier',),\n",
       " ('Poodle',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Norfolk Terrier',),\n",
       " ('Norfolk Terrier',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labrador Retriever-Rottweiler Mix',),\n",
       " ('Mixed',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Australian Shepherd',),\n",
       " ('Greyhound',),\n",
       " ('Staffordshire Bull Terrier-Great Dane Mix',),\n",
       " ('Mixed',),\n",
       " ('Wire Fox Terrier',),\n",
       " ('Golden Retriever',),\n",
       " ('French Spaniel',),\n",
       " ('Samoyed',),\n",
       " ('Coton de Tulear',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Poodle-Maltese Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Golden Retriever',),\n",
       " ('Border Collie',),\n",
       " ('Maltese-Yorkshire Terrier Mix',),\n",
       " ('Cockapoo',),\n",
       " ('Collie',),\n",
       " ('Labrador Retriever-German Shepherd Dog Mix',),\n",
       " (\"I Don't Know\",),\n",
       " ('Border Collie',),\n",
       " ('Mixed',),\n",
       " ('Pekingese-Shih Tzu Mix',),\n",
       " ('Mixed',),\n",
       " ('Siberian Husky',),\n",
       " ('Shih Tzu',),\n",
       " ('Rhodesian Ridgeback',),\n",
       " ('Mixed',),\n",
       " ('Dalmatian',),\n",
       " ('Dalmatian',),\n",
       " ('Labrador Retriever',),\n",
       " ('Staffordshire Bull Terrier-Miniature Schnauzer Mix',),\n",
       " ('Cocker Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Greyhound',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Poodle',),\n",
       " ('Puggle',),\n",
       " ('Mixed',),\n",
       " ('Cockapoo',),\n",
       " ('Beagle- Mix',),\n",
       " ('Rhodesian Ridgeback',),\n",
       " ('Havanese',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Havanese',),\n",
       " ('Yorkshire Terrier',),\n",
       " ('Dalmatian',),\n",
       " ('Dalmatian',),\n",
       " ('Belgian Malinois',),\n",
       " ('Mixed',),\n",
       " ('Rhodesian Ridgeback',),\n",
       " ('Labradoodle',),\n",
       " ('Australian Shepherd',),\n",
       " ('Australian Shepherd',),\n",
       " ('Dalmatian',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Australian Shepherd-Australian Cattle Dog Mix',),\n",
       " (\"I Don't Know\",),\n",
       " ('French Bulldog',),\n",
       " ('Boston Terrier',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Pomeranian',),\n",
       " ('Whippet',),\n",
       " ('Golden Doodle',),\n",
       " ('Border Collie',),\n",
       " ('Border Collie',),\n",
       " ('Border Collie',),\n",
       " ('Poodle-Labrador Retriever Mix',),\n",
       " ('Pug-Wire Fox Terrier Mix',),\n",
       " ('Greyhound',),\n",
       " ('Pug-Wire Fox Terrier Mix',),\n",
       " ('Pug-Smooth Fox Terrier Mix',),\n",
       " ('Pembroke Welsh Corgi',),\n",
       " ('Australian Shepherd',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Wire Fox Terrier',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Bearded Collie-Beagle Mix',),\n",
       " ('Golden Retriever',),\n",
       " ('Border Collie-Australian Cattle Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Great Dane',),\n",
       " ('Brussels Griffon',),\n",
       " ('Poodle',),\n",
       " ('Irish Setter',),\n",
       " ('Poodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Puggle',),\n",
       " ('Shih Tzu',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('Poodle-Dachshund Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Cocker Spaniel',),\n",
       " ('Miniature Schnauzer',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Mixed',),\n",
       " ('Pug-Chihuahua Mix',),\n",
       " ('Mixed',),\n",
       " ('Coton de Tulear',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Papillon',),\n",
       " ('Mastiff',),\n",
       " ('Shih Tzu',),\n",
       " ('Polish Lowland Sheepdog',),\n",
       " ('Miniature Pinscher',),\n",
       " ('English Springer Spaniel',),\n",
       " (\"I Don't Know\",),\n",
       " ('American Eskimo Dog',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Soft Coated Wheaten Terrier',),\n",
       " ('Mixed',),\n",
       " ('Chinese Crested-Poodle Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('American Pit Bull Terrier-Australian Cattle Dog Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Catahoula Leopard Dog-Rottweiler Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Belgian Tervuren',),\n",
       " ('Belgian Tervuren',),\n",
       " ('Greyhound',),\n",
       " ('Nova Scotia Duck Tolling Retriever',),\n",
       " ('Mixed',),\n",
       " ('Australian Shepherd-Border Collie Mix',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('West Highland White Terrier',),\n",
       " ('Poodle-Shih Tzu Mix',),\n",
       " ('Boxer-Border Collie Mix',),\n",
       " ('Shih Tzu',),\n",
       " ('Other',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Border Collie',),\n",
       " (\"I Don't Know\",),\n",
       " ('Golden Retriever',),\n",
       " ('Great Dane-Irish Wolfhound Mix',),\n",
       " ('Pyrenean Shepherd',),\n",
       " ('Pyrenean Shepherd',),\n",
       " ('Labrador Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Other',),\n",
       " ('Chinese Shar-Pei',),\n",
       " ('Mastiff',),\n",
       " ('French Bulldog',),\n",
       " ('Australian Shepherd',),\n",
       " ('Australian Shepherd',),\n",
       " ('Australian Shepherd',),\n",
       " ('Dachshund',),\n",
       " (\"I Don't Know\",),\n",
       " ('Golden Retriever',),\n",
       " ('Maltese',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Labradoodle',),\n",
       " ('Labradoodle',),\n",
       " ('Border Collie',),\n",
       " ('Lhasa Apso',),\n",
       " ('Greyhound',),\n",
       " ('Mixed',),\n",
       " ('Shih Tzu',),\n",
       " ('Dogue de Bordeaux-Boxer Mix',),\n",
       " ('Golden Doodle',),\n",
       " ('Belgian Malinois',),\n",
       " ('Greyhound',),\n",
       " ('Belgian Malinois',),\n",
       " ('Akita',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Australian Shepherd',),\n",
       " ('Bulldog',),\n",
       " ('Golden Doodle',),\n",
       " ('American Staffordshire Terrier-Catahoula Leopard Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Scottish Terrier',),\n",
       " ('Bulldog',),\n",
       " ('Shih Tzu-Pekingese Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Rat Terrier',),\n",
       " ('Border Terrier',),\n",
       " ('Poodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Boxer',),\n",
       " ('Beagle-Labrador Retriever Mix',),\n",
       " ('Australian Shepherd',),\n",
       " ('Golden Retriever',),\n",
       " ('Dachshund-Beagle Mix',),\n",
       " ('Silky Terrier',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Mixed',),\n",
       " ('Golden Doodle',),\n",
       " ('Scottish Terrier',),\n",
       " ('-German Shepherd Dog Mix',),\n",
       " ('Boxer',),\n",
       " ('Labrador Retriever',),\n",
       " ('Keeshond',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('German Shorthaired Pointer',),\n",
       " ('Coton de Tulear',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Belgian Malinois',),\n",
       " ('Chihuahua',),\n",
       " ('Poodle',),\n",
       " ('American Pit Bull Terrier',),\n",
       " ('Bernese Mountain Dog',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog-Chow Chow Mix',),\n",
       " ('Labrador Retriever-Golden Retriever Mix',),\n",
       " ('Weimaraner',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Border Collie-Australian Shepherd Mix',),\n",
       " ('Labrador Retriever- Mix',),\n",
       " ('Border Collie',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Beagle-Australian Cattle Dog Mix',),\n",
       " ('Mixed',),\n",
       " ('Pembroke Welsh Corgi-Great Pyrenees Mix',),\n",
       " ('Mixed',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Australian Shepherd-Pembroke Welsh Corgi Mix',),\n",
       " ('Mixed',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Labrador Retriever',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Australian Shepherd',),\n",
       " ('French Bulldog',),\n",
       " ('Labrador Retriever',),\n",
       " ('Golden Doodle',),\n",
       " ('Chesapeake Bay Retriever',),\n",
       " ('Poodle',),\n",
       " ('Golden Doodle',),\n",
       " ('Labrador Retriever',),\n",
       " ('Maltese-Poodle Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labradoodle',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Mixed',),\n",
       " ('Dachshund',),\n",
       " ('Havanese',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Boxer',),\n",
       " ('Mixed',),\n",
       " ('Boxer',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Border Collie',),\n",
       " ('Mixed',),\n",
       " ('Australian Shepherd',),\n",
       " ('Afghan Hound-Golden Retriever Mix',),\n",
       " ('Mixed',),\n",
       " ('Dachshund',),\n",
       " ('Shorkie',),\n",
       " ('Field Spaniel',),\n",
       " ('Mixed',),\n",
       " ('Cavalier King Charles Spaniel',),\n",
       " ('Poodle',),\n",
       " ('Chihuahua-American Staffordshire Terrier Mix',),\n",
       " ('Newfoundland',),\n",
       " ('Mixed',),\n",
       " ('Yorkshire Terrier',),\n",
       " ('Australian Cattle Dog',),\n",
       " ('Other',),\n",
       " ('English Cocker Spaniel',),\n",
       " ('Boxer',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Labradoodle',),\n",
       " ('Mixed',),\n",
       " ('Pug',),\n",
       " ('Bluetick Coonhound',),\n",
       " ('Pug-Miniature Pinscher Mix',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Whippet-Chinese Shar-Pei Mix',),\n",
       " ('German Shepherd Dog',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Boxer-Bulldog Mix',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Other',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Golden Retriever',),\n",
       " ('Labrador Retriever',),\n",
       " ('Labradoodle',),\n",
       " ('Papillon',),\n",
       " ('Poodle',),\n",
       " ('Mixed',),\n",
       " ('Poodle',),\n",
       " ('Portuguese Water Dog',),\n",
       " ('Vizsla- Mix',),\n",
       " ('Boxer',),\n",
       " ('Chow Chow-Labrador Retriever Mix',),\n",
       " ('Rat Terrier',),\n",
       " ('Rhodesian Ridgeback-Boxer Mix',),\n",
       " ('Labrador Retriever',),\n",
       " ('Mixed',),\n",
       " ('Border Collie-Whippet Mix',),\n",
       " ('Mixed',),\n",
       " ('Russell Terrier',),\n",
       " ('Other',),\n",
       " ('Belgian Malinois',),\n",
       " ('German Shepherd Dog',),\n",
       " ('Border Collie-Pembroke Welsh Corgi Mix',),\n",
       " ('Mixed',),\n",
       " ('Pug',),\n",
       " ...]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT breed\n",
    "FROM dogs;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "When you do so, you will see a line at the top of the output panel that says \"35050 rows affected\".  This means that there are 35050 rows of data in the dogs table.  Each row of the output lists the name of the breed of the dog represented by that entry.  Notice that some breed names are listed multiple times, because several dogs of that breed have participated in the Dognition tests.\n",
    "\n",
    "If you scroll all the way down to the bottom of the output, you will see a notification that says \"35050 rows, truncated to displaylimit of 1000.\"  We have set up a display limit of 1000 rows in these notebooks to ensure that our database servers are not overloaded, and to reduce the amount of time you have to wait for the query output. However, in a actual scenario these limits would not necessarily be in place for you.  Therefore, before we go any further, I want to show you how you could restrict the number of rows outputted by a query.\n",
    "\n",
    "![Alt text](https://duke.box.com/shared/static/dm85qcbpdsza8tc7be8x7tc6x6tr2xjq.jpg)\n",
    "\n",
    "\n",
    "\n",
    "## Using LIMIT to restrict the number of rows in your output (and prevent system crashes)\n",
    "\n",
    "The MySQL clause you should use is called LIMIT, and it is always placed at the very end of your query.  The simplest version of a limit statement looks like this:\n",
    "\n",
    "```mySQL\n",
    "SELECT breed\n",
    "FROM dogs LIMIT 5;\n",
    "```\n",
    "\n",
    "The \"5\" in this case indicates that you will only see the first 5 rows of data you select.  \n",
    "\n",
    "**Question 7: In the next cell, try entering a query that will let you see the first 10 rows of the breed column in the dogs table.**\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>breed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shetland Sheepdog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Golden Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu-Poodle Mix</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Labrador Retriever',),\n",
       " ('Shetland Sheepdog',),\n",
       " ('Golden Retriever',),\n",
       " ('Golden Retriever',),\n",
       " ('Shih Tzu',),\n",
       " ('Siberian Husky',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Shih Tzu-Poodle Mix',)]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT breed\n",
    "FROM dogs LIMIT 10;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can also select rows of data from different parts of the output table, rather than always just starting at the beginning.  To do this, use the OFFSET clause after LIMIT. The number after the OFFSET clause indicates from which row the output will begin querying.  Note that the offset of Row 1 of a table is actually 0.  Therefore, in the following query:\n",
    "\n",
    "```mySQL\n",
    "SELECT breed\n",
    "FROM dogs LIMIT 10 OFFSET 5;\n",
    "```\n",
    "\n",
    "10 rows of data will be returned, starting at Row 6.  \n",
    "\n",
    "An alternative way to write the OFFSET clause in the query is:\n",
    "\n",
    "```mySQL\n",
    "SELECT breed\n",
    "FROM dogs LIMIT 5, 10;\n",
    "```\n",
    "\n",
    "In this notation, the offset is the number before the comma, and the number of rows returned is the number after the comma.  \n",
    "\n",
    "**Try it yourself:**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>breed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Siberian Husky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mixed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Labrador Retriever</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Shih Tzu-Poodle Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Pembroke Welsh Corgi Mix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Vizsla</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Boxer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Siberian Husky',),\n",
       " ('Shih Tzu',),\n",
       " ('Mixed',),\n",
       " ('Labrador Retriever',),\n",
       " ('Shih Tzu-Poodle Mix',),\n",
       " ('German Shepherd Dog-Pembroke Welsh Corgi Mix',),\n",
       " ('Vizsla',),\n",
       " ('Pug',),\n",
       " ('Boxer',),\n",
       " ('German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix',)]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT breed\n",
    "FROM dogs LIMIT 10 OFFSET 5;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The LIMIT command is one of the pieces of syntax that can vary across database platforms.  MySQL uses LIMIT to restrict the output, but other databases including Teradata use a statement called \"TOP\" instead.  Oracle has yet another syntax:\n",
    "\n",
    "http://www.tutorialspoint.com/sql/sql-top-clause.htm\n",
    "\n",
    "Make sure to look up the correct syntax for the database type you are using.\n",
    "\n",
    "\n",
    "## Using SELECT to query multiple columns\n",
    "\n",
    "Now that we know how to limit our output, we are ready to make our SELECT statement work a little harder.  The SELECT statement can be used to select multiple columns as well as a single column.  The output of the query will depend on the order of the columns you enter after the SELECT statement in your query.  <mark> When you enter column names, separate each name with a comma, but do NOT include a comma after the last column name. </mark>\n",
    "\n",
    "**Try the following query with different orders of the column names to observe the differences in output (I will include a LIMIT statement in many of the examples I use in the rest of the course, but feel free to change or remove them to explore different aspects of the data):**\n",
    "\n",
    "```mySQL\n",
    "SELECT breed, breed_type, breed_group\n",
    "FROM dogs LIMIT 5, 10;\n",
    "```\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>breed_group</th>\n",
       "        <th>breed</th>\n",
       "        <th>breed_type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Working</td>\n",
       "        <td>Siberian Husky</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Toy</td>\n",
       "        <td>Shih Tzu</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>Mixed</td>\n",
       "        <td>Mixed Breed/ Other/ I Don&#x27;t Know</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Sporting</td>\n",
       "        <td>Labrador Retriever</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>Shih Tzu-Poodle Mix</td>\n",
       "        <td>Cross Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>German Shepherd Dog-Pembroke Welsh Corgi Mix</td>\n",
       "        <td>Cross Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Sporting</td>\n",
       "        <td>Vizsla</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Toy</td>\n",
       "        <td>Pug</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Working</td>\n",
       "        <td>Boxer</td>\n",
       "        <td>Pure Breed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix</td>\n",
       "        <td>Cross Breed</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Working', 'Siberian Husky', 'Pure Breed'),\n",
       " ('Toy', 'Shih Tzu', 'Pure Breed'),\n",
       " (None, 'Mixed', \"Mixed Breed/ Other/ I Don't Know\"),\n",
       " ('Sporting', 'Labrador Retriever', 'Pure Breed'),\n",
       " (None, 'Shih Tzu-Poodle Mix', 'Cross Breed'),\n",
       " (None, 'German Shepherd Dog-Pembroke Welsh Corgi Mix', 'Cross Breed'),\n",
       " ('Sporting', 'Vizsla', 'Pure Breed'),\n",
       " ('Toy', 'Pug', 'Pure Breed'),\n",
       " ('Working', 'Boxer', 'Pure Breed'),\n",
       " (None, 'German Shepherd Dog-Nova Scotia Duck Tolling Retriever Mix', 'Cross Breed')]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT breed_group, breed, breed_type\n",
    "FROM dogs LIMIT 5, 10;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Another trick to know about when using SELECT is that <mark> you can use an asterisk as a \"wild card\" to return all the data in a table.</mark>  (A wild card is defined as a character that will represent or match any character or sequence of characters in a query.) <mark> Take note, this is very risky to do if you do not limit your output or if you don't know how many data are in your database, so use the wild card with caution.</mark>  However, it is a handy tool to use when you don't have all the column names easily available or when you know you want to query an entire table.  \n",
    "\n",
    "The syntax is as follows:\n",
    "\n",
    "```mySQL\n",
    "SELECT *\n",
    "FROM dogs LIMIT 5, 10;\n",
    "```\n",
    "\n",
    "**Question 8: Try using the wild card to query the reviews table:**\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>rating</th>\n",
       "        <th>created_at</th>\n",
       "        <th>updated_at</th>\n",
       "        <th>user_guid</th>\n",
       "        <th>dog_guid</th>\n",
       "        <th>subcategory_name</th>\n",
       "        <th>test_name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>2014-05-01 22:38:33</td>\n",
       "        <td>2014-05-01 22:38:33</td>\n",
       "        <td>ce47172c-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce405c52-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>2014-05-01 22:45:24</td>\n",
       "        <td>2014-05-01 22:45:24</td>\n",
       "        <td>ce47172c-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce405c52-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>2014-05-02 01:32:49</td>\n",
       "        <td>2014-05-02 01:32:49</td>\n",
       "        <td>ce471eca-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce405e28-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Treat Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>2014-05-02 01:52:06</td>\n",
       "        <td>2014-05-02 01:52:06</td>\n",
       "        <td>ce471eca-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce405e28-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Cunning</td>\n",
       "        <td>Turn Your Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>2014-05-02 02:58:23</td>\n",
       "        <td>2014-05-02 02:58:23</td>\n",
       "        <td>ce261aa4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Treat Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>2014-05-02 03:05:29</td>\n",
       "        <td>2014-05-02 03:05:29</td>\n",
       "        <td>ce261aa4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Arm Pointing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>2014-05-02 03:12:47</td>\n",
       "        <td>2014-05-02 03:12:47</td>\n",
       "        <td>ce261aa4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Foot Pointing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>2014-05-02 11:50:27</td>\n",
       "        <td>2014-05-02 11:50:27</td>\n",
       "        <td>ce261bd0-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce260c1c-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Shaker Game</td>\n",
       "        <td>Shaker Warm-Up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>2014-05-02 18:48:36</td>\n",
       "        <td>2014-05-02 18:48:36</td>\n",
       "        <td>ce2ab050-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce3fd48a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>2014-05-02 18:52:07</td>\n",
       "        <td>2014-05-02 18:52:07</td>\n",
       "        <td>ce2ab050-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>ce3fd48a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Warm-up</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(6, datetime.datetime(2014, 5, 1, 22, 38, 33), datetime.datetime(2014, 5, 1, 22, 38, 33), 'ce47172c-7144-11e5-ba71-058fbc01cf0b', 'ce405c52-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Game'),\n",
       " (3, datetime.datetime(2014, 5, 1, 22, 45, 24), datetime.datetime(2014, 5, 1, 22, 45, 24), 'ce47172c-7144-11e5-ba71-058fbc01cf0b', 'ce405c52-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Game'),\n",
       " (0, datetime.datetime(2014, 5, 2, 1, 32, 49), datetime.datetime(2014, 5, 2, 1, 32, 49), 'ce471eca-7144-11e5-ba71-058fbc01cf0b', 'ce405e28-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Treat Warm-up'),\n",
       " (9, datetime.datetime(2014, 5, 2, 1, 52, 6), datetime.datetime(2014, 5, 2, 1, 52, 6), 'ce471eca-7144-11e5-ba71-058fbc01cf0b', 'ce405e28-7144-11e5-ba71-058fbc01cf0b', 'Cunning', 'Turn Your Back'),\n",
       " (0, datetime.datetime(2014, 5, 2, 2, 58, 23), datetime.datetime(2014, 5, 2, 2, 58, 23), 'ce261aa4-7144-11e5-ba71-058fbc01cf0b', 'ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Treat Warm-up'),\n",
       " (6, datetime.datetime(2014, 5, 2, 3, 5, 29), datetime.datetime(2014, 5, 2, 3, 5, 29), 'ce261aa4-7144-11e5-ba71-058fbc01cf0b', 'ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Arm Pointing'),\n",
       " (2, datetime.datetime(2014, 5, 2, 3, 12, 47), datetime.datetime(2014, 5, 2, 3, 12, 47), 'ce261aa4-7144-11e5-ba71-058fbc01cf0b', 'ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Foot Pointing'),\n",
       " (7, datetime.datetime(2014, 5, 2, 11, 50, 27), datetime.datetime(2014, 5, 2, 11, 50, 27), 'ce261bd0-7144-11e5-ba71-058fbc01cf0b', 'ce260c1c-7144-11e5-ba71-058fbc01cf0b', 'Shaker Game', 'Shaker Warm-Up'),\n",
       " (0, datetime.datetime(2014, 5, 2, 18, 48, 36), datetime.datetime(2014, 5, 2, 18, 48, 36), 'ce2ab050-7144-11e5-ba71-058fbc01cf0b', 'ce3fd48a-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Game'),\n",
       " (0, datetime.datetime(2014, 5, 2, 18, 52, 7), datetime.datetime(2014, 5, 2, 18, 52, 7), 'ce2ab050-7144-11e5-ba71-058fbc01cf0b', 'ce3fd48a-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Warm-up')]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT *\n",
    "FROM reviews LIMIT 5, 10;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "NOTE: if you do this for the dogs table, your output will be too wide to see at one time in the dialog box.  Use the scroll bars at bottom and to the right of the dialog box to see the entire output table.  \n",
    "   \n",
    "     \n",
    "SELECT statements can also be used to make new derivations of individual columns using \"+\" for addition, \"-\" for subtraction, \"\\*\" for multiplication, or \"/\" for division.  For example, if you wanted the median inter-test intervals in hours instead of minutes or days, you could query:\n",
    "\n",
    "```mySQL\n",
    "SELECT median_iti_minutes / 60\n",
    "FROM dogs LIMIT 5, 10;\n",
    "```\n",
    "\n",
    "**Question 9: Go ahead and try it, adding in a column to your output that shows you the original median_iti in minutes.**\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>median_iti_minutes / 60</th>\n",
       "        <th>median_iti_minutes</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.085555555285</td>\n",
       "        <td>5.1333333171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.0080555537245</td>\n",
       "        <td>0.48333322347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.11138889105833334</td>\n",
       "        <td>6.6833334635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.081111109755</td>\n",
       "        <td>4.8666665853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.09333333570666666</td>\n",
       "        <td>5.6000001424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.14027777682833334</td>\n",
       "        <td>8.4166666097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.10750000088166667</td>\n",
       "        <td>6.4500000529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.09583333319833334</td>\n",
       "        <td>5.7499999919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.094444443495</td>\n",
       "        <td>5.6666666097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0.09055555474166667</td>\n",
       "        <td>5.4333332845</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(0.085555555285, '5.1333333171'),\n",
       " (0.0080555537245, '0.48333322347'),\n",
       " (0.11138889105833334, '6.6833334635'),\n",
       " (0.081111109755, '4.8666665853'),\n",
       " (0.09333333570666666, '5.6000001424'),\n",
       " (0.14027777682833334, '8.4166666097'),\n",
       " (0.10750000088166667, '6.4500000529'),\n",
       " (0.09583333319833334, '5.7499999919'),\n",
       " (0.094444443495, '5.6666666097'),\n",
       " (0.09055555474166667, '5.4333332845')]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT median_iti_minutes / 60, median_iti_minutes\n",
    "FROM dogs LIMIT 5, 10;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Now it's time to practice writing your own SELECT statements.  \n",
    "\n",
    "**Question 10: How would you retrieve the first 15 rows of data from the dog_guid, subcategory_name, and test_name fields of the Reviews table, in that order?**   \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "15 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>dog_guid</th>\n",
       "        <th>subcategory_name</th>\n",
       "        <th>test_name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce3ac77e-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2aedcc-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2aedcc-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2aedcc-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Treat Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce405c52-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce405c52-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce405c52-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce405e28-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Treat Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce405e28-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Cunning</td>\n",
       "        <td>Turn Your Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Treat Warm-up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Arm Pointing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce2609c4-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Communication</td>\n",
       "        <td>Foot Pointing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce260c1c-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Shaker Game</td>\n",
       "        <td>Shaker Warm-Up</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce3fd48a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Yawn Game</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ce3fd48a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>Empathy</td>\n",
       "        <td>Eye Contact Warm-up</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('ce3ac77e-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Warm-up'),\n",
       " ('ce2aedcc-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Warm-up'),\n",
       " ('ce2aedcc-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Game'),\n",
       " ('ce2aedcc-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Treat Warm-up'),\n",
       " ('ce405c52-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Warm-up'),\n",
       " ('ce405c52-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Game'),\n",
       " ('ce405c52-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Game'),\n",
       " ('ce405e28-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Treat Warm-up'),\n",
       " ('ce405e28-7144-11e5-ba71-058fbc01cf0b', 'Cunning', 'Turn Your Back'),\n",
       " ('ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Treat Warm-up'),\n",
       " ('ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Arm Pointing'),\n",
       " ('ce2609c4-7144-11e5-ba71-058fbc01cf0b', 'Communication', 'Foot Pointing'),\n",
       " ('ce260c1c-7144-11e5-ba71-058fbc01cf0b', 'Shaker Game', 'Shaker Warm-Up'),\n",
       " ('ce3fd48a-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Yawn Game'),\n",
       " ('ce3fd48a-7144-11e5-ba71-058fbc01cf0b', 'Empathy', 'Eye Contact Warm-up')]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT dog_guid, subcategory_name, test_name \n",
    "FROM reviews LIMIT 15;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Question 11: How would you retrieve 10 rows of data from the activity_type, created_at, and updated_at fields of the site_activities table, starting at row 50?  What do you notice about the created_at and updated_at fields?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>activity_type</th>\n",
       "        <th>created_at</th>\n",
       "        <th>updated_at</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 20:55:08</td>\n",
       "        <td>2013-07-25 20:55:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 20:55:07</td>\n",
       "        <td>2013-07-25 20:55:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 20:55:50</td>\n",
       "        <td>2013-07-25 20:55:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 20:56:09</td>\n",
       "        <td>2013-07-25 20:56:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 20:56:21</td>\n",
       "        <td>2013-07-25 20:56:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 21:00:31</td>\n",
       "        <td>2013-07-25 21:00:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 21:02:29</td>\n",
       "        <td>2013-07-25 21:02:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 21:02:31</td>\n",
       "        <td>2013-07-25 21:02:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 21:02:45</td>\n",
       "        <td>2013-07-25 21:02:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>point_in_cat</td>\n",
       "        <td>2013-07-25 21:05:41</td>\n",
       "        <td>2013-07-25 21:05:41</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('point_in_cat', datetime.datetime(2013, 7, 25, 20, 55, 8), datetime.datetime(2013, 7, 25, 20, 55, 8)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 20, 55, 7), datetime.datetime(2013, 7, 25, 20, 55, 7)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 20, 55, 50), datetime.datetime(2013, 7, 25, 20, 55, 50)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 20, 56, 9), datetime.datetime(2013, 7, 25, 20, 56, 9)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 20, 56, 21), datetime.datetime(2013, 7, 25, 20, 56, 21)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 21, 0, 31), datetime.datetime(2013, 7, 25, 21, 0, 31)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 21, 2, 29), datetime.datetime(2013, 7, 25, 21, 2, 29)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 21, 2, 31), datetime.datetime(2013, 7, 25, 21, 2, 31)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 21, 2, 45), datetime.datetime(2013, 7, 25, 21, 2, 45)),\n",
       " ('point_in_cat', datetime.datetime(2013, 7, 25, 21, 5, 41), datetime.datetime(2013, 7, 25, 21, 5, 41))]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT activity_type, created_at, updated_at\n",
    "FROM site_activities LIMIT 10 OFFSET 49;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Question 12: How would you retrieve 20 rows of data from all the columns in the users table, starting from row 2000?  What do you notice about the free_start_user field?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "20 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>sign_in_count</th>\n",
       "        <th>created_at</th>\n",
       "        <th>updated_at</th>\n",
       "        <th>max_dogs</th>\n",
       "        <th>membership_id</th>\n",
       "        <th>subscribed</th>\n",
       "        <th>exclude</th>\n",
       "        <th>free_start_user</th>\n",
       "        <th>last_active_at</th>\n",
       "        <th>membership_type</th>\n",
       "        <th>user_guid</th>\n",
       "        <th>city</th>\n",
       "        <th>state</th>\n",
       "        <th>zip</th>\n",
       "        <th>country</th>\n",
       "        <th>utc_correction</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-21 23:19:08</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce245818-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>2013-02-21 23:25:03</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce24589a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 01:21:20</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce245a3e-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 03:05:42</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce245c50-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>2013-02-22 03:29:06</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2014-06-23 23:31:28</td>\n",
       "        <td>1</td>\n",
       "        <td>ce245d7c-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 15:05:13</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce245eda-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 16:30:17</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce245f98-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 18:16:05</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce24611e-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>2013-02-22 20:26:53</td>\n",
       "        <td>2015-01-28 20:51:53</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce24629a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-22 23:14:40</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>2</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce2465ec-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-23 13:05:38</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce246772-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>2013-02-23 16:56:55</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>2</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce24688a-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>2013-02-23 21:07:41</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce246b28-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-23 21:22:09</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce246b82-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>2013-02-23 22:48:15</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>2</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2014-08-04 14:16:34</td>\n",
       "        <td>2</td>\n",
       "        <td>ce246c40-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>2013-02-24 00:14:21</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>2</td>\n",
       "        <td>2</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>2</td>\n",
       "        <td>ce246dbc-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-24 07:34:32</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce246e84-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-24 14:48:43</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce246ff6-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-24 15:34:10</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce247050-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>2013-02-24 15:36:19</td>\n",
       "        <td>2015-01-28 20:51:54</td>\n",
       "        <td>1</td>\n",
       "        <td>1</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>1</td>\n",
       "        <td>ce2470aa-7144-11e5-ba71-058fbc01cf0b</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(1, datetime.datetime(2013, 2, 21, 23, 19, 8), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 1, None, None, None, 1, 'ce245818-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (3, datetime.datetime(2013, 2, 21, 23, 25, 3), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 2, 1, None, None, None, 2, 'ce24589a-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 1, 21, 20), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 1, None, None, None, 1, 'ce245a3e-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 3, 5, 42), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 2, 1, None, None, None, 2, 'ce245c50-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (5, datetime.datetime(2013, 2, 22, 3, 29, 6), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 1, None, None, datetime.datetime(2014, 6, 23, 23, 31, 28), 1, 'ce245d7c-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 15, 5, 13), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 1, None, None, None, 1, 'ce245eda-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 16, 30, 17), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 2, 1, None, None, None, 2, 'ce245f98-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 18, 16, 5), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 0, None, None, None, 1, 'ce24611e-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (3, datetime.datetime(2013, 2, 22, 20, 26, 53), datetime.datetime(2015, 1, 28, 20, 51, 53), 1, 1, 1, None, None, None, 1, 'ce24629a-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 22, 23, 14, 40), datetime.datetime(2015, 1, 28, 20, 51, 54), 2, 2, 1, None, None, None, 2, 'ce2465ec-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 23, 13, 5, 38), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 1, None, None, None, 1, 'ce246772-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (3, datetime.datetime(2013, 2, 23, 16, 56, 55), datetime.datetime(2015, 1, 28, 20, 51, 54), 2, 2, 1, None, None, None, 2, 'ce24688a-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (3, datetime.datetime(2013, 2, 23, 21, 7, 41), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 2, 1, None, None, None, 2, 'ce246b28-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 23, 21, 22, 9), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 1, None, None, None, 1, 'ce246b82-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (4, datetime.datetime(2013, 2, 23, 22, 48, 15), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 2, 1, None, None, datetime.datetime(2014, 8, 4, 14, 16, 34), 2, 'ce246c40-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (4, datetime.datetime(2013, 2, 24, 0, 14, 21), datetime.datetime(2015, 1, 28, 20, 51, 54), 2, 2, 0, None, None, None, 2, 'ce246dbc-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 24, 7, 34, 32), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 0, None, None, None, 1, 'ce246e84-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 24, 14, 48, 43), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 1, None, None, None, 1, 'ce246ff6-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 24, 15, 34, 10), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 1, None, None, None, 1, 'ce247050-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None),\n",
       " (1, datetime.datetime(2013, 2, 24, 15, 36, 19), datetime.datetime(2015, 1, 28, 20, 51, 54), 1, 1, 0, None, None, None, 1, 'ce2470aa-7144-11e5-ba71-058fbc01cf0b', None, None, None, None, None)]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT * \n",
    "FROM users LIMIT 20 OFFSET 1999;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## You have already learned how to see all the data in your database!  Congratulations!  \n",
    "\n",
    "Feel free to practice any other queries you are interested in below:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}