Computer Science/SQL/Lab2-TCHIBOZO.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# TP2 - DB Normalization and Querying\n",
    "\n",
    "The objectives of this TP are:\n",
    "1. Apply normalization 1NF -> 2NF -> 3NF\n",
    "2. Perform SQL queries on the normalized database\n",
    "\n",
    "In this TP, we will use a database **`wine.db`** (available in the course's website) containing wine information related to 'production' and 'sales'. \n",
    "\n",
    "> Production <---> Wine <---> Sales\n",
    "\n",
    "\n",
    "---\n",
    "\n",
    "### Working with db files in Jupyter\n",
    "- Python provides an interface for SQLite through the *sqlite3* module\n",
    "- The **`%%sql`** magic builds upon it (and other tools) to enable the usage of SQL commands within a Jupyter Notebook as in common SQL clients.\n",
    "- Before proceeding, make sure that **`wine.db`** is in the same path as this notebook.\n",
    "  - If **`wine.db`** is not in the same path, an empty **`wine.db`** file will be created, resulting in errors in later steps of the TP.\n",
    "- The SQLite module in Python commits transactions automatically, this means that any change in the DB is immediately written to the file, e.g. creating/deleting tables.\n",
    "  -  For this reason, it is recommended to have a backup of **`wine.db`** as it is provided in the course's website.\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**`wine.db`** contains the following unnormalized tables:\n",
    "\n",
    "<center>**Master1**</center>\n",
    "\n",
    "|*Attribute*|         *Description*          |\n",
    "| -------   |--------------------------------|\n",
    "| NV        | Wine number                    |\n",
    "| CRU       | Vineyard or group of vineyards |\n",
    "| DEGRE     | Alcohol content                |\n",
    "| MILL      | Vintage year                   |\n",
    "| QTE       | Number of bottles harvested    |\n",
    "| NP        | Producer number                |\n",
    "| NOM       | Producer's last name           |\n",
    "| PRENOM    | Producer's first name          |\n",
    "| REGION    | Production region              |\n",
    "\n",
    "From wikipedia:\n",
    "\n",
    "__Cru__: Often used to indicate a specifically named and legally defined vineyard or ensemble of vineyards and the vines \"which grow on [such] a reputed terroir; by extension of good quality.\" The term is also used to refer to the wine produced from such vines.\n",
    "\n",
    "\n",
    "<center>**Master2**</center>\n",
    "\n",
    "|*Attribute*|                         *Description*                  |\n",
    "| -------   |--------------------------------------------------------|\n",
    "| NV        | Wine number                                            |\n",
    "| CRU       | Vineyard or group of vineyards                         |\n",
    "| DEGRE     | Alcohol content                                        |\n",
    "| MILL      | Vintage year                                           |\n",
    "| DATES     | Buying date                                            |\n",
    "| LIEU      | Place where the wine was sold                          |\n",
    "| QTE       | Number of bottles bought                               |\n",
    "| NB        | Client (buveur) number                                 |\n",
    "| NOM       | Client's last name                                     |\n",
    "| PRENOM    | Client's first name                                    |\n",
    "| TYPE      | Type of client by volume of purchases                  |\n",
    "| REGION    | Administrative Region (different to production region) |\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3    # Python interface for SQLite databases"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def printSchema(connection):\n",
    "    # Function to print the DB schema\n",
    "    # Source: http://stackoverflow.com/a/35092773/4765776\n",
    "    for (tableName,) in connection.execute(\n",
    "        \"\"\"\n",
    "        select NAME from SQLITE_MASTER where TYPE='table' order by NAME;\n",
    "        \"\"\"\n",
    "    ):\n",
    "        print(\"{}:\".format(tableName))\n",
    "        for (\n",
    "            columnID, columnName, columnType,\n",
    "            columnNotNull, columnDefault, columnPK,\n",
    "        ) in connection.execute(\"pragma table_info('{}');\".format(tableName)):\n",
    "            print(\"  {id}: {name}({type}){null}{default}{pk}\".format(\n",
    "                id=columnID,\n",
    "                name=columnName,\n",
    "                type=columnType,\n",
    "                null=\" not null\" if columnNotNull else \"\",\n",
    "                default=\" [{}]\".format(columnDefault) if columnDefault else \"\",\n",
    "                pk=\" *{}\".format(columnPK) if columnPK else \"\",\n",
    "            ))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Database schema:\n",
      "MASTER1:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "  4: QTE(NUM)\n",
      "  5: NP(NUM)\n",
      "  6: NOM(TEXT)\n",
      "  7: PRENOM(TEXT)\n",
      "  8: REGION(TEXT)\n",
      "MASTER1sub1:\n",
      "  0: NP(NUM)\n",
      "  1: NOM(TEXT)\n",
      "  2: PRENOM(TEXT)\n",
      "MASTER1sub2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "MASTER1sub3:\n",
      "  0: NP(NUM)\n",
      "  1: NV(NUM)\n",
      "  2: QTE(NUM)\n",
      "  3: REGION(TEXT)\n",
      "MASTER2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "  4: DATES(DATE)\n",
      "  5: LIEU(TEXT)\n",
      "  6: QTE(NUM)\n",
      "  7: NB(NUM)\n",
      "  8: NOM(TEXT)\n",
      "  9: PRENOM(TEXT)\n",
      "  10: TYPE(TEXT)\n",
      "  11: REGION(TEXT)\n",
      "MASTER2sub1:\n",
      "  0: NB(NUM)\n",
      "  1: NOM(TEXT)\n",
      "  2: PRENOM(TEXT)\n",
      "  3: TYPE(TEXT)\n",
      "MASTER2sub2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "MASTER2sub3:\n",
      "  0: LIEU(TEXT)\n",
      "  1: REGION(TEXT)\n",
      "MASTER2sub4:\n",
      "  0: NB(NUM)\n",
      "  1: NV(NUM)\n",
      "  2: LIEU(TEXT)\n",
      "  3: QTE(NUM)\n",
      "  4: DATES(NUM)\n"
     ]
    }
   ],
   "source": [
    "conn = sqlite3.connect('C://Users//Max Tchibozo//Desktop//wine.db')\n",
    "c = conn.cursor()\n",
    "print(\"Database schema:\")\n",
    "printSchema(conn)           # An usefull way to viualize the content of the database"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "From this point we will use __%%sql__ magic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The sql extension is already loaded. To reload it, use:\n",
      "  %reload_ext sql\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'Connected: @wine.db'"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%load_ext sql\n",
    "%sql sqlite:///wine.db"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PART I: Database normalization"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The first task on this TP is the normalization of the wine data. In its current state both tables **Master1** and **Master2** are in the First Normal Form (1NF).\n",
    "\n",
    "By inspecting the content of these tables we can see that multiple tuples have NULL values."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NV</th>\n",
       "        <th>CRU</th>\n",
       "        <th>DEGRE</th>\n",
       "        <th>MILL</th>\n",
       "        <th>DATES</th>\n",
       "        <th>LIEU</th>\n",
       "        <th>QTE</th>\n",
       "        <th>NB</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "        <th>TYPE</th>\n",
       "        <th>REGION</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>11</td>\n",
       "        <td>Breton</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>13</td>\n",
       "        <td>Barthes</td>\n",
       "        <td>Roland</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>16</td>\n",
       "        <td>Balzac</td>\n",
       "        <td>Honore de</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>18</td>\n",
       "        <td>Celine</td>\n",
       "        <td>Louis Ferdinand</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>20</td>\n",
       "        <td>Chateaubriand</td>\n",
       "        <td>Francois-Rene de</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>21</td>\n",
       "        <td>Corbiere</td>\n",
       "        <td>Tristan</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>23</td>\n",
       "        <td>Corneille</td>\n",
       "        <td>Pierre</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>25</td>\n",
       "        <td>Char</td>\n",
       "        <td>Rene</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>27</td>\n",
       "        <td>Dumas</td>\n",
       "        <td>Alexandre</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>29</td>\n",
       "        <td>Fournier</td>\n",
       "        <td>Alain</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>32</td>\n",
       "        <td>Eluard</td>\n",
       "        <td>Paul</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>34</td>\n",
       "        <td>Mauriac</td>\n",
       "        <td>Francois</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>35</td>\n",
       "        <td>Fromentin</td>\n",
       "        <td>Eugene</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>36</td>\n",
       "        <td>Maurois</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>37</td>\n",
       "        <td>Freud</td>\n",
       "        <td>Sigmund</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>39</td>\n",
       "        <td>Montesquieu</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>42</td>\n",
       "        <td>Goethe</td>\n",
       "        <td>Johann Wolfgang von</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>43</td>\n",
       "        <td>Musset</td>\n",
       "        <td>Alfred de</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>46</td>\n",
       "        <td>Hugo</td>\n",
       "        <td>Victor</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>47</td>\n",
       "        <td>Gary</td>\n",
       "        <td>Romain</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>51</td>\n",
       "        <td>Lafargue</td>\n",
       "        <td>Paul</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>53</td>\n",
       "        <td>Lamartine</td>\n",
       "        <td>Alphonse de</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>54</td>\n",
       "        <td>Aurele</td>\n",
       "        <td>Marc</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>55</td>\n",
       "        <td>Michelet</td>\n",
       "        <td>Jules</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>56</td>\n",
       "        <td>Nerval</td>\n",
       "        <td>Gerard de</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>57</td>\n",
       "        <td>Marx</td>\n",
       "        <td>Karl</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>59</td>\n",
       "        <td>Nietzsche</td>\n",
       "        <td>Friedrich</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>63</td>\n",
       "        <td>Maupassant</td>\n",
       "        <td>Guy de</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>64</td>\n",
       "        <td>Platon</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>65</td>\n",
       "        <td>Pascal</td>\n",
       "        <td>Blaise</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>66</td>\n",
       "        <td>Perec</td>\n",
       "        <td>Georges</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>67</td>\n",
       "        <td>Nin</td>\n",
       "        <td>Anais</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>68</td>\n",
       "        <td>Prevert</td>\n",
       "        <td>Jacques</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>69</td>\n",
       "        <td>Queneau</td>\n",
       "        <td>Raymond</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>70</td>\n",
       "        <td>Paulhan</td>\n",
       "        <td>Jean</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>71</td>\n",
       "        <td>Radiguet</td>\n",
       "        <td>Raymond</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>72</td>\n",
       "        <td>Rabelais</td>\n",
       "        <td>Francois</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>73</td>\n",
       "        <td>Poe</td>\n",
       "        <td>Allan Edgard</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>74</td>\n",
       "        <td>Rimbaud</td>\n",
       "        <td>Arthur</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>76</td>\n",
       "        <td>Racine</td>\n",
       "        <td>Jean</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>77</td>\n",
       "        <td>Rousseau</td>\n",
       "        <td>Jean-Jacques</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>78</td>\n",
       "        <td>Sandier</td>\n",
       "        <td>Jules</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>79</td>\n",
       "        <td>Sade</td>\n",
       "        <td>Donatien Alphonse Fran¿¿s de</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>81</td>\n",
       "        <td>Sartre</td>\n",
       "        <td>Jean-Paul</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>83</td>\n",
       "        <td>Sophocle</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>84</td>\n",
       "        <td>Sue</td>\n",
       "        <td>Eugene</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>85</td>\n",
       "        <td>Segalen</td>\n",
       "        <td>Victor</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>86</td>\n",
       "        <td>Saint Exupery</td>\n",
       "        <td>Antoine de</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>87</td>\n",
       "        <td>Segur</td>\n",
       "        <td>Comtesse de</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>88</td>\n",
       "        <td>Shakespeare</td>\n",
       "        <td>William</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>89</td>\n",
       "        <td>Stendhal</td>\n",
       "        <td>None</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>90</td>\n",
       "        <td>Vian</td>\n",
       "        <td>Boris</td>\n",
       "        <td>petit</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>91</td>\n",
       "        <td>Verlaine</td>\n",
       "        <td>Paul</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>93</td>\n",
       "        <td>Virgile</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>95</td>\n",
       "        <td>Zorn</td>\n",
       "        <td>Fritz</td>\n",
       "        <td>moyen</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>98</td>\n",
       "        <td>Maturin</td>\n",
       "        <td>Robert</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>99</td>\n",
       "        <td>Cesar</td>\n",
       "        <td>Jules</td>\n",
       "        <td>gros</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>Sylvaner</td>\n",
       "        <td>11.2</td>\n",
       "        <td>1982</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>13</td>\n",
       "        <td>Cotes du Rhone</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>14</td>\n",
       "        <td>Chateau Chalon</td>\n",
       "        <td>10.9</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>15</td>\n",
       "        <td>Cote de Brouilly</td>\n",
       "        <td>11.9</td>\n",
       "        <td>1973</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>17</td>\n",
       "        <td>Meursault</td>\n",
       "        <td>11.4</td>\n",
       "        <td>1975</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>18</td>\n",
       "        <td>Chambolle Musigny</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>19</td>\n",
       "        <td>Clos du roi</td>\n",
       "        <td>11.2</td>\n",
       "        <td>1972</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>25</td>\n",
       "        <td>Chapelle Chambertin</td>\n",
       "        <td>10.5</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>27</td>\n",
       "        <td>Puligny Montrachet</td>\n",
       "        <td>11</td>\n",
       "        <td>1974</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>29</td>\n",
       "        <td>Corton</td>\n",
       "        <td>11.6</td>\n",
       "        <td>1972</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>30</td>\n",
       "        <td>Bourgogne Passe Tout Grains</td>\n",
       "        <td>12</td>\n",
       "        <td>1979</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>33</td>\n",
       "        <td>Santenay</td>\n",
       "        <td>12</td>\n",
       "        <td>1972</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>34</td>\n",
       "        <td>Montagny</td>\n",
       "        <td>11.2</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>36</td>\n",
       "        <td>Chorey les Beaunes</td>\n",
       "        <td>11</td>\n",
       "        <td>1955</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>37</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>10</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>39</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>None</td>\n",
       "        <td>1973</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>44</td>\n",
       "        <td>Moulin a vent</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>46</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>11</td>\n",
       "        <td>1983</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>47</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>11</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>48</td>\n",
       "        <td>Cote de Brouilly</td>\n",
       "        <td>12</td>\n",
       "        <td>1899</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>49</td>\n",
       "        <td>Morgon</td>\n",
       "        <td>12</td>\n",
       "        <td>1984</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>51</td>\n",
       "        <td>Chenas</td>\n",
       "        <td>10</td>\n",
       "        <td>1975</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>52</td>\n",
       "        <td>Brouilly</td>\n",
       "        <td>None</td>\n",
       "        <td>1975</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>57</td>\n",
       "        <td>Crozes Hermitage</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1974</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>58</td>\n",
       "        <td>Crozes Hermitage</td>\n",
       "        <td>12.5</td>\n",
       "        <td>1975</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>59</td>\n",
       "        <td>Crozes - Hermitage</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1972</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>60</td>\n",
       "        <td>Crozes-Hermitage</td>\n",
       "        <td>11</td>\n",
       "        <td>1983</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>61</td>\n",
       "        <td>Hermitage</td>\n",
       "        <td>12</td>\n",
       "        <td>1979</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>65</td>\n",
       "        <td>Rochgrande</td>\n",
       "        <td>10.8</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>66</td>\n",
       "        <td>Tavel</td>\n",
       "        <td>11</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>67</td>\n",
       "        <td>Gewurztraminer</td>\n",
       "        <td>12.5</td>\n",
       "        <td>1968</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>68</td>\n",
       "        <td>Riesling</td>\n",
       "        <td>14</td>\n",
       "        <td>1962</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>69</td>\n",
       "        <td>Tokay d&#x27;Alsace</td>\n",
       "        <td>11</td>\n",
       "        <td>1982</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>70</td>\n",
       "        <td>Sylvaner</td>\n",
       "        <td>11</td>\n",
       "        <td>1982</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>71</td>\n",
       "        <td>Palette</td>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>72</td>\n",
       "        <td>Cassis</td>\n",
       "        <td>10</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>73</td>\n",
       "        <td>Bellet</td>\n",
       "        <td>11</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>75</td>\n",
       "        <td>Arbois</td>\n",
       "        <td>11</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>76</td>\n",
       "        <td>Chateau Chalon</td>\n",
       "        <td>12</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>77</td>\n",
       "        <td>Etoile</td>\n",
       "        <td>11</td>\n",
       "        <td>1979</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>88</td>\n",
       "        <td>Cotes de Provence</td>\n",
       "        <td>10</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>89</td>\n",
       "        <td>Cotes de Provence</td>\n",
       "        <td>11</td>\n",
       "        <td>1969</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>90</td>\n",
       "        <td>Palette</td>\n",
       "        <td>11</td>\n",
       "        <td>1969</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>91</td>\n",
       "        <td>Cassis</td>\n",
       "        <td>11</td>\n",
       "        <td>1979</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>92</td>\n",
       "        <td>Coteaux de Pierevert</td>\n",
       "        <td>None</td>\n",
       "        <td>1967</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>93</td>\n",
       "        <td>Blanquette de Limoux</td>\n",
       "        <td>None</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>94</td>\n",
       "        <td>Cotes du Rousillon</td>\n",
       "        <td>None</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>95</td>\n",
       "        <td>Cotes du Rousillon</td>\n",
       "        <td>12</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>96</td>\n",
       "        <td>Saint Chinian</td>\n",
       "        <td>11</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>97</td>\n",
       "        <td>Saint Chinian</td>\n",
       "        <td>11</td>\n",
       "        <td>1976</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>98</td>\n",
       "        <td>Corbieres</td>\n",
       "        <td>10</td>\n",
       "        <td>1978</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>99</td>\n",
       "        <td>Cote Rotie</td>\n",
       "        <td>13</td>\n",
       "        <td>1994</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>101</td>\n",
       "        <td>Saint Veran</td>\n",
       "        <td>12.5</td>\n",
       "        <td>1973</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>107</td>\n",
       "        <td>Sancerre</td>\n",
       "        <td>14</td>\n",
       "        <td>1998</td>\n",
       "        <td>None</td>\n",
       "        <td>None</td>\n",
       "        <td>None</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>Mercurey</td>\n",
       "        <td>11.5</td>\n",
       "        <td>1980</td>\n",
       "        <td>1977-11-02</td>\n",
       "        <td>BORDEAUX</td>\n",
       "        <td>33</td>\n",
       "        <td>2</td>\n",
       "        <td>Artaud</td>\n",
       "        <td>Antonin</td>\n",
       "        <td>moyen</td>\n",
       "        <td> NOUVELLE-AQUITAINE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>11.8</td>\n",
       "        <td>1979</td>\n",
       "        <td>1977-12-31</td>\n",
       "        <td>BORDEAUX</td>\n",
       "        <td>10</td>\n",
       "        <td>3</td>\n",
       "        <td>Aron</td>\n",
       "        <td>Raymond</td>\n",
       "        <td>gros</td>\n",
       "        <td> NOUVELLE-AQUITAINE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>38</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>11</td>\n",
       "        <td>1977</td>\n",
       "        <td>1981-08-06</td>\n",
       "        <td>CAEN</td>\n",
       "        <td>5</td>\n",
       "        <td>12</td>\n",
       "        <td>Bataille</td>\n",
       "        <td>Georges</td>\n",
       "        <td>moyen</td>\n",
       "        <td> NORMANDIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>38</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>11</td>\n",
       "        <td>1977</td>\n",
       "        <td>1981-05-12</td>\n",
       "        <td>CAEN</td>\n",
       "        <td>2</td>\n",
       "        <td>14</td>\n",
       "        <td>Bory</td>\n",
       "        <td>Jean Louis</td>\n",
       "        <td>gros</td>\n",
       "        <td> NORMANDIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>11</td>\n",
       "        <td>1974</td>\n",
       "        <td>1983-02-21</td>\n",
       "        <td>CAEN</td>\n",
       "        <td>3</td>\n",
       "        <td>5</td>\n",
       "        <td>Audiberti</td>\n",
       "        <td>Jacques</td>\n",
       "        <td>petit</td>\n",
       "        <td> NORMANDIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>Grands Echezeaux</td>\n",
       "        <td>11.7</td>\n",
       "        <td>1968</td>\n",
       "        <td>1987-04-28</td>\n",
       "        <td>CANNES</td>\n",
       "        <td>7</td>\n",
       "        <td>58</td>\n",
       "        <td>Marivaux</td>\n",
       "        <td>Pierre Carlet de Chamblain de</td>\n",
       "        <td>gros</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>Cotes de Nuits</td>\n",
       "        <td>None</td>\n",
       "        <td>1978</td>\n",
       "        <td>1987-04-05</td>\n",
       "        <td>CANNES</td>\n",
       "        <td>21</td>\n",
       "        <td>62</td>\n",
       "        <td>Proust</td>\n",
       "        <td>Marcel</td>\n",
       "        <td>moyen</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>11</td>\n",
       "        <td>1974</td>\n",
       "        <td>1982-11-04</td>\n",
       "        <td>CANNES</td>\n",
       "        <td>10</td>\n",
       "        <td>41</td>\n",
       "        <td>Gauthier</td>\n",
       "        <td>Theophile</td>\n",
       "        <td>petit</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>11.8</td>\n",
       "        <td>1979</td>\n",
       "        <td>1982-10-30</td>\n",
       "        <td>CHALON SUR SAONE</td>\n",
       "        <td>500</td>\n",
       "        <td>2</td>\n",
       "        <td>Artaud</td>\n",
       "        <td>Antonin</td>\n",
       "        <td>moyen</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>12</td>\n",
       "        <td>1943</td>\n",
       "        <td>1982-04-02</td>\n",
       "        <td>DIJON</td>\n",
       "        <td>25</td>\n",
       "        <td>17</td>\n",
       "        <td>Camus</td>\n",
       "        <td>Albert</td>\n",
       "        <td>petit</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>12</td>\n",
       "        <td>1943</td>\n",
       "        <td>1980-12-31</td>\n",
       "        <td>DIJON</td>\n",
       "        <td>12</td>\n",
       "        <td>19</td>\n",
       "        <td>Ciceron</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>24</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1971</td>\n",
       "        <td>1986-06-12</td>\n",
       "        <td>LE CHESNAY</td>\n",
       "        <td>14</td>\n",
       "        <td>100</td>\n",
       "        <td>Woolf</td>\n",
       "        <td>Virginia</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>12</td>\n",
       "        <td>1943</td>\n",
       "        <td>1986-08-10</td>\n",
       "        <td>LE CHESNAY</td>\n",
       "        <td>4</td>\n",
       "        <td>92</td>\n",
       "        <td>Verne</td>\n",
       "        <td>Jules</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Pommard</td>\n",
       "        <td>11.7</td>\n",
       "        <td>1976</td>\n",
       "        <td>1983-06-29</td>\n",
       "        <td>LILLE</td>\n",
       "        <td>5</td>\n",
       "        <td>52</td>\n",
       "        <td>Carroll</td>\n",
       "        <td>Lewis</td>\n",
       "        <td>petit</td>\n",
       "        <td> HAUTS-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1975</td>\n",
       "        <td>1979-11-01</td>\n",
       "        <td>LILLE</td>\n",
       "        <td>10</td>\n",
       "        <td>9</td>\n",
       "        <td>Ajar</td>\n",
       "        <td>Emile</td>\n",
       "        <td>petit</td>\n",
       "        <td> HAUTS-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>Chapelle Chambertin</td>\n",
       "        <td>11.9</td>\n",
       "        <td>1973</td>\n",
       "        <td>1979-05-12</td>\n",
       "        <td>LILLE</td>\n",
       "        <td>1</td>\n",
       "        <td>10</td>\n",
       "        <td>Andersen</td>\n",
       "        <td>Yann</td>\n",
       "        <td>gros</td>\n",
       "        <td> HAUTS-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>Julienas</td>\n",
       "        <td>11.3</td>\n",
       "        <td>1974</td>\n",
       "        <td>1983-12-25</td>\n",
       "        <td>LYON</td>\n",
       "        <td>2</td>\n",
       "        <td>48</td>\n",
       "        <td>Hardy</td>\n",
       "        <td>Thomas</td>\n",
       "        <td>moyen</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>Chapelle Chambertin</td>\n",
       "        <td>11.9</td>\n",
       "        <td>1973</td>\n",
       "        <td>1982-03-26</td>\n",
       "        <td>LYON</td>\n",
       "        <td>20</td>\n",
       "        <td>5</td>\n",
       "        <td>Audiberti</td>\n",
       "        <td>Jacques</td>\n",
       "        <td>petit</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>11.8</td>\n",
       "        <td>1979</td>\n",
       "        <td>1983-06-06</td>\n",
       "        <td>LYON</td>\n",
       "        <td>10</td>\n",
       "        <td>5</td>\n",
       "        <td>Audiberti</td>\n",
       "        <td>Jacques</td>\n",
       "        <td>petit</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>Monthelie</td>\n",
       "        <td>11.4</td>\n",
       "        <td>1968</td>\n",
       "        <td>1984-12-31</td>\n",
       "        <td>LYON</td>\n",
       "        <td>6</td>\n",
       "        <td>26</td>\n",
       "        <td>Diderot</td>\n",
       "        <td>Denis</td>\n",
       "        <td>moyen</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>Monthelie</td>\n",
       "        <td>11.4</td>\n",
       "        <td>1968</td>\n",
       "        <td>1978-12-25</td>\n",
       "        <td>LYON</td>\n",
       "        <td>100</td>\n",
       "        <td>28</td>\n",
       "        <td>Dostoievsky</td>\n",
       "        <td>Fiodor</td>\n",
       "        <td>gros</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>35</td>\n",
       "        <td>Auxey Duresses</td>\n",
       "        <td>11.3</td>\n",
       "        <td>1914</td>\n",
       "        <td>1981-12-25</td>\n",
       "        <td>LYON</td>\n",
       "        <td>80</td>\n",
       "        <td>30</td>\n",
       "        <td>La Fontaine</td>\n",
       "        <td>Jean de</td>\n",
       "        <td>petit</td>\n",
       "        <td>&nbsp;&nbsp;AUVERGNE-RHÔNE-ALPES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1978</td>\n",
       "        <td>1987-12-24</td>\n",
       "        <td>MERCUREY</td>\n",
       "        <td>5</td>\n",
       "        <td>49</td>\n",
       "        <td>Kafka</td>\n",
       "        <td>Franz</td>\n",
       "        <td>petit</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Pommard</td>\n",
       "        <td>11.7</td>\n",
       "        <td>1976</td>\n",
       "        <td>1984-11-04</td>\n",
       "        <td>MERCUREY</td>\n",
       "        <td>50</td>\n",
       "        <td>2</td>\n",
       "        <td>Artaud</td>\n",
       "        <td>Antonin</td>\n",
       "        <td>moyen</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>11.2</td>\n",
       "        <td>1981</td>\n",
       "        <td>1978-01-21</td>\n",
       "        <td>NANCY</td>\n",
       "        <td>36</td>\n",
       "        <td>3</td>\n",
       "        <td>Aron</td>\n",
       "        <td>Raymond</td>\n",
       "        <td>gros</td>\n",
       "        <td> GRAND EST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>11</td>\n",
       "        <td>1974</td>\n",
       "        <td>1982-11-05</td>\n",
       "        <td>NANCY</td>\n",
       "        <td>11</td>\n",
       "        <td>40</td>\n",
       "        <td>Moliere</td>\n",
       "        <td>None</td>\n",
       "        <td>petit</td>\n",
       "        <td> GRAND EST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1978</td>\n",
       "        <td>1978-11-01</td>\n",
       "        <td>NICE</td>\n",
       "        <td>6</td>\n",
       "        <td>7</td>\n",
       "        <td>Anouilh</td>\n",
       "        <td>Jean</td>\n",
       "        <td>moyen</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Cote de Brouilly</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1980</td>\n",
       "        <td>1978-06-12</td>\n",
       "        <td>NICE</td>\n",
       "        <td>20</td>\n",
       "        <td>61</td>\n",
       "        <td>Mallarme</td>\n",
       "        <td>Stephane</td>\n",
       "        <td>petit</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>12</td>\n",
       "        <td>1943</td>\n",
       "        <td>1982-03-25</td>\n",
       "        <td>NICE</td>\n",
       "        <td>30</td>\n",
       "        <td>15</td>\n",
       "        <td>Baudelaire</td>\n",
       "        <td>Charles</td>\n",
       "        <td>petit</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>11.5</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>1</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>10.9</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>6</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>Grands Echezeaux</td>\n",
       "        <td>11.7</td>\n",
       "        <td>1968</td>\n",
       "        <td>1987-09-19</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>24</td>\n",
       "        <td>4</td>\n",
       "        <td>Apollinaire</td>\n",
       "        <td>Guillaume</td>\n",
       "        <td>moyen</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1975</td>\n",
       "        <td>1982-09-15</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>78</td>\n",
       "        <td>1</td>\n",
       "        <td>Aristote</td>\n",
       "        <td>None</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>Meursault</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>2</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Cote de Brouilly</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>3</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>26</td>\n",
       "        <td>Chateau Corton Grancey</td>\n",
       "        <td>None</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>4</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>28</td>\n",
       "        <td>Volnay</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>5</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>32</td>\n",
       "        <td>Pouilly Vinzelles</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1968</td>\n",
       "        <td>1983-02-14</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>3</td>\n",
       "        <td>22</td>\n",
       "        <td>Cocteau</td>\n",
       "        <td>Jean</td>\n",
       "        <td>gros</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>32</td>\n",
       "        <td>Pouilly Vinzelles</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1968</td>\n",
       "        <td>1980-12-31</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>7</td>\n",
       "        <td>24</td>\n",
       "        <td>Courrier</td>\n",
       "        <td>Paul Louis</td>\n",
       "        <td>moyen</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>42</td>\n",
       "        <td>Beaujolais Primeur</td>\n",
       "        <td>12</td>\n",
       "        <td>1983</td>\n",
       "        <td>1983-03-10</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>4</td>\n",
       "        <td>100</td>\n",
       "        <td>Woolf</td>\n",
       "        <td>Virginia</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>43</td>\n",
       "        <td>Fleurie</td>\n",
       "        <td>11.4</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>7</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>50</td>\n",
       "        <td>Chenas</td>\n",
       "        <td>11.5</td>\n",
       "        <td>1984</td>\n",
       "        <td>1988-02-23</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>1</td>\n",
       "        <td>38</td>\n",
       "        <td>Montaigne</td>\n",
       "        <td>Michel de</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>62</td>\n",
       "        <td>Gigondas</td>\n",
       "        <td>11</td>\n",
       "        <td>1978</td>\n",
       "        <td>1980-12-21</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>5</td>\n",
       "        <td>96</td>\n",
       "        <td>Wilde</td>\n",
       "        <td>Oscar</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>63</td>\n",
       "        <td>Coteaux du Tricastin</td>\n",
       "        <td>10</td>\n",
       "        <td>1978</td>\n",
       "        <td>1982-02-02</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>12</td>\n",
       "        <td>3</td>\n",
       "        <td>Aron</td>\n",
       "        <td>Raymond</td>\n",
       "        <td>gros</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>64</td>\n",
       "        <td>Coteaux du Tricastin</td>\n",
       "        <td>11</td>\n",
       "        <td>1974</td>\n",
       "        <td>1983-12-31</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>1</td>\n",
       "        <td>97</td>\n",
       "        <td>Vigny</td>\n",
       "        <td>Alfred de</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>74</td>\n",
       "        <td>Arbois</td>\n",
       "        <td>12</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>8</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>78</td>\n",
       "        <td>Etoile</td>\n",
       "        <td>12</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>9</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>79</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>10</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>80</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>11</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>81</td>\n",
       "        <td>Cornas</td>\n",
       "        <td>11.1</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>12</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>82</td>\n",
       "        <td>Cornas</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>13</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>83</td>\n",
       "        <td>Saint Amour</td>\n",
       "        <td>10</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>14</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>84</td>\n",
       "        <td>Rasteau</td>\n",
       "        <td>10</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>15</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>85</td>\n",
       "        <td>Tavel</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>16</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>86</td>\n",
       "        <td>Tavel</td>\n",
       "        <td>11</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>17</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>87</td>\n",
       "        <td>Cotes de Provence</td>\n",
       "        <td>None</td>\n",
       "        <td>1980</td>\n",
       "        <td>2015-10-16</td>\n",
       "        <td>PARIS</td>\n",
       "        <td>18</td>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>None</td>\n",
       "        <td>1974</td>\n",
       "        <td>1987-12-24</td>\n",
       "        <td>PARLY</td>\n",
       "        <td>22</td>\n",
       "        <td>80</td>\n",
       "        <td>Sand</td>\n",
       "        <td>Georges</td>\n",
       "        <td>petit</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>Pommard</td>\n",
       "        <td>None</td>\n",
       "        <td>1972</td>\n",
       "        <td>1988-03-20</td>\n",
       "        <td>PARLY</td>\n",
       "        <td>23</td>\n",
       "        <td>82</td>\n",
       "        <td>Roussel</td>\n",
       "        <td>Rene</td>\n",
       "        <td>petit</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>11.5</td>\n",
       "        <td>1980</td>\n",
       "        <td>1983-12-31</td>\n",
       "        <td>RENNES</td>\n",
       "        <td>1</td>\n",
       "        <td>45</td>\n",
       "        <td>Giono</td>\n",
       "        <td>Jean</td>\n",
       "        <td>petit</td>\n",
       "        <td> BRETAGNE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>None</td>\n",
       "        <td>1974</td>\n",
       "        <td>1985-05-23</td>\n",
       "        <td>ROCQUENCOURT</td>\n",
       "        <td>22</td>\n",
       "        <td>75</td>\n",
       "        <td>Ronsard</td>\n",
       "        <td>Pierre</td>\n",
       "        <td>moyen</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>53</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>None</td>\n",
       "        <td>1975</td>\n",
       "        <td>1983-06-06</td>\n",
       "        <td>ROCQUENCOURT</td>\n",
       "        <td>10</td>\n",
       "        <td>12</td>\n",
       "        <td>Bataille</td>\n",
       "        <td>Georges</td>\n",
       "        <td>moyen</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>54</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>10.5</td>\n",
       "        <td>1976</td>\n",
       "        <td>1983-05-05</td>\n",
       "        <td>ROCQUENCOURT</td>\n",
       "        <td>120</td>\n",
       "        <td>8</td>\n",
       "        <td>Aragon</td>\n",
       "        <td>Louis</td>\n",
       "        <td>gros</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>55</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>12.1</td>\n",
       "        <td>1978</td>\n",
       "        <td>1983-05-05</td>\n",
       "        <td>ROCQUENCOURT</td>\n",
       "        <td>130</td>\n",
       "        <td>9</td>\n",
       "        <td>Ajar</td>\n",
       "        <td>Emile</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>56</td>\n",
       "        <td>Saint Amour</td>\n",
       "        <td>None</td>\n",
       "        <td>1974</td>\n",
       "        <td>1983-05-05</td>\n",
       "        <td>ROCQUENCOURT</td>\n",
       "        <td>80</td>\n",
       "        <td>5</td>\n",
       "        <td>Audiberti</td>\n",
       "        <td>Jacques</td>\n",
       "        <td>petit</td>\n",
       "        <td> ÎLE-DE-FRANCE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>10.9</td>\n",
       "        <td>1980</td>\n",
       "        <td>1981-06-29</td>\n",
       "        <td>SENS</td>\n",
       "        <td>4</td>\n",
       "        <td>50</td>\n",
       "        <td>Lautreamont</td>\n",
       "        <td>None</td>\n",
       "        <td>moyen</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>Clairette de Die</td>\n",
       "        <td>12</td>\n",
       "        <td>1976</td>\n",
       "        <td>1985-12-29</td>\n",
       "        <td>SENS</td>\n",
       "        <td>3</td>\n",
       "        <td>94</td>\n",
       "        <td>Zola</td>\n",
       "        <td>Emile</td>\n",
       "        <td>moyen</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>42</td>\n",
       "        <td>Beaujolais Primeur</td>\n",
       "        <td>12</td>\n",
       "        <td>1983</td>\n",
       "        <td>1985-07-27</td>\n",
       "        <td>SENS</td>\n",
       "        <td>3</td>\n",
       "        <td>94</td>\n",
       "        <td>Zola</td>\n",
       "        <td>Emile</td>\n",
       "        <td>moyen</td>\n",
       "        <td> BOURGOGNE-FRANCHE-COMTÉ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>12.3</td>\n",
       "        <td>1975</td>\n",
       "        <td>1980-05-12</td>\n",
       "        <td>TOULON</td>\n",
       "        <td>8</td>\n",
       "        <td>60</td>\n",
       "        <td>Ovide</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>Chapelle Chambertin</td>\n",
       "        <td>11.9</td>\n",
       "        <td>1973</td>\n",
       "        <td>1907-04-21</td>\n",
       "        <td>TOULON</td>\n",
       "        <td>9</td>\n",
       "        <td>61</td>\n",
       "        <td>Mallarme</td>\n",
       "        <td>Stephane</td>\n",
       "        <td>petit</td>\n",
       "        <td> PROVENCE-ALPES-CÔTE D&#x27;AZUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>10.9</td>\n",
       "        <td>1980</td>\n",
       "        <td>1982-11-05</td>\n",
       "        <td>TOULOUSE</td>\n",
       "        <td>12</td>\n",
       "        <td>8</td>\n",
       "        <td>Aragon</td>\n",
       "        <td>Louis</td>\n",
       "        <td>gros</td>\n",
       "        <td> OCCITANIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>Gentil</td>\n",
       "        <td>10.7</td>\n",
       "        <td>1975</td>\n",
       "        <td>1982-11-05</td>\n",
       "        <td>TOULOUSE</td>\n",
       "        <td>36</td>\n",
       "        <td>6</td>\n",
       "        <td>Arrabal</td>\n",
       "        <td>Fernando</td>\n",
       "        <td>gros</td>\n",
       "        <td> OCCITANIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>12</td>\n",
       "        <td>1943</td>\n",
       "        <td>1982-04-01</td>\n",
       "        <td>TOULOUSE</td>\n",
       "        <td>1</td>\n",
       "        <td>33</td>\n",
       "        <td>Flaubert</td>\n",
       "        <td>Gustave</td>\n",
       "        <td>moyen</td>\n",
       "        <td> OCCITANIE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>Clairette de Die</td>\n",
       "        <td>12</td>\n",
       "        <td>1976</td>\n",
       "        <td>1988-04-01</td>\n",
       "        <td>TOULOUSE</td>\n",
       "        <td>2</td>\n",
       "        <td>31</td>\n",
       "        <td>Dante</td>\n",
       "        <td>None</td>\n",
       "        <td>gros</td>\n",
       "        <td> OCCITANIE</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(None, None, None, None, None, None, None, 11, 'Breton', 'Andre', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 13, 'Barthes', 'Roland', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 16, 'Balzac', 'Honore de', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 18, 'Celine', 'Louis Ferdinand', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 20, 'Chateaubriand', 'Francois-Rene de', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 21, 'Corbiere', 'Tristan', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 23, 'Corneille', 'Pierre', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 25, 'Char', 'Rene', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 27, 'Dumas', 'Alexandre', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 29, 'Fournier', 'Alain', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 32, 'Eluard', 'Paul', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 34, 'Mauriac', 'Francois', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 35, 'Fromentin', 'Eugene', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 36, 'Maurois', 'Andre', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 37, 'Freud', 'Sigmund', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 39, 'Montesquieu', None, 'gros', None),\n",
       " (None, None, None, None, None, None, None, 42, 'Goethe', 'Johann Wolfgang von', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 43, 'Musset', 'Alfred de', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 46, 'Hugo', 'Victor', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 47, 'Gary', 'Romain', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 51, 'Lafargue', 'Paul', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 53, 'Lamartine', 'Alphonse de', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 54, 'Aurele', 'Marc', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 55, 'Michelet', 'Jules', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 56, 'Nerval', 'Gerard de', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 57, 'Marx', 'Karl', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 59, 'Nietzsche', 'Friedrich', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 63, 'Maupassant', 'Guy de', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 64, 'Platon', None, 'gros', None),\n",
       " (None, None, None, None, None, None, None, 65, 'Pascal', 'Blaise', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 66, 'Perec', 'Georges', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 67, 'Nin', 'Anais', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 68, 'Prevert', 'Jacques', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 69, 'Queneau', 'Raymond', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 70, 'Paulhan', 'Jean', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 71, 'Radiguet', 'Raymond', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 72, 'Rabelais', 'Francois', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 73, 'Poe', 'Allan Edgard', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 74, 'Rimbaud', 'Arthur', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 76, 'Racine', 'Jean', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 77, 'Rousseau', 'Jean-Jacques', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 78, 'Sandier', 'Jules', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 79, 'Sade', 'Donatien Alphonse Fran¿¿s de', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 81, 'Sartre', 'Jean-Paul', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 83, 'Sophocle', None, 'gros', None),\n",
       " (None, None, None, None, None, None, None, 84, 'Sue', 'Eugene', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 85, 'Segalen', 'Victor', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 86, 'Saint Exupery', 'Antoine de', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 87, 'Segur', 'Comtesse de', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 88, 'Shakespeare', 'William', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 89, 'Stendhal', None, 'petit', None),\n",
       " (None, None, None, None, None, None, None, 90, 'Vian', 'Boris', 'petit', None),\n",
       " (None, None, None, None, None, None, None, 91, 'Verlaine', 'Paul', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 93, 'Virgile', None, 'gros', None),\n",
       " (None, None, None, None, None, None, None, 95, 'Zorn', 'Fritz', 'moyen', None),\n",
       " (None, None, None, None, None, None, None, 98, 'Maturin', 'Robert', 'gros', None),\n",
       " (None, None, None, None, None, None, None, 99, 'Cesar', 'Jules', 'gros', None),\n",
       " (11, 'Sylvaner', 11.2, 1982, None, None, None, None, None, None, None, None),\n",
       " (13, 'Cotes du Rhone', 12.3, 1968, None, None, None, None, None, None, None, None),\n",
       " (14, 'Chateau Chalon', 10.9, 1978, None, None, None, None, None, None, None, None),\n",
       " (15, 'Cote de Brouilly', 11.9, 1973, None, None, None, None, None, None, None, None),\n",
       " (17, 'Meursault', 11.4, 1975, None, None, None, None, None, None, None, None),\n",
       " (18, 'Chambolle Musigny', 12.3, 1968, None, None, None, None, None, None, None, None),\n",
       " (19, 'Clos du roi', 11.2, 1972, None, None, None, None, None, None, None, None),\n",
       " (25, 'Chapelle Chambertin', 10.5, 1968, None, None, None, None, None, None, None, None),\n",
       " (27, 'Puligny Montrachet', 11, 1974, None, None, None, None, None, None, None, None),\n",
       " (29, 'Corton', 11.6, 1972, None, None, None, None, None, None, None, None),\n",
       " (30, 'Bourgogne Passe Tout Grains', 12, 1979, None, None, None, None, None, None, None, None),\n",
       " (33, 'Santenay', 12, 1972, None, None, None, None, None, None, None, None),\n",
       " (34, 'Montagny', 11.2, 1978, None, None, None, None, None, None, None, None),\n",
       " (36, 'Chorey les Beaunes', 11, 1955, None, None, None, None, None, None, None, None),\n",
       " (37, 'Savigny les Beaunes', 10, 1978, None, None, None, None, None, None, None, None),\n",
       " (39, 'Savigny les Beaunes', None, 1973, None, None, None, None, None, None, None, None),\n",
       " (44, 'Moulin a vent', None, 1983, None, None, None, None, None, None, None, None),\n",
       " (45, 'Chiroubles', None, 1983, None, None, None, None, None, None, None, None),\n",
       " (46, 'Chiroubles', 11, 1983, None, None, None, None, None, None, None, None),\n",
       " (47, 'Chiroubles', 11, 1978, None, None, None, None, None, None, None, None),\n",
       " (48, 'Cote de Brouilly', 12, 1899, None, None, None, None, None, None, None, None),\n",
       " (49, 'Morgon', 12, 1984, None, None, None, None, None, None, None, None),\n",
       " (51, 'Chenas', 10, 1975, None, None, None, None, None, None, None, None),\n",
       " (52, 'Brouilly', None, 1975, None, None, None, None, None, None, None, None),\n",
       " (57, 'Crozes Hermitage', 12.1, 1974, None, None, None, None, None, None, None, None),\n",
       " (58, 'Crozes Hermitage', 12.5, 1975, None, None, None, None, None, None, None, None),\n",
       " (59, 'Crozes - Hermitage', 12.3, 1972, None, None, None, None, None, None, None, None),\n",
       " (60, 'Crozes-Hermitage', 11, 1983, None, None, None, None, None, None, None, None),\n",
       " (61, 'Hermitage', 12, 1979, None, None, None, None, None, None, None, None),\n",
       " (65, 'Rochgrande', 10.8, 1968, None, None, None, None, None, None, None, None),\n",
       " (66, 'Tavel', 11, 1968, None, None, None, None, None, None, None, None),\n",
       " (67, 'Gewurztraminer', 12.5, 1968, None, None, None, None, None, None, None, None),\n",
       " (68, 'Riesling', 14, 1962, None, None, None, None, None, None, None, None),\n",
       " (69, \"Tokay d'Alsace\", 11, 1982, None, None, None, None, None, None, None, None),\n",
       " (70, 'Sylvaner', 11, 1982, None, None, None, None, None, None, None, None),\n",
       " (71, 'Palette', 11, 1981, None, None, None, None, None, None, None, None),\n",
       " (72, 'Cassis', 10, 1978, None, None, None, None, None, None, None, None),\n",
       " (73, 'Bellet', 11, 1976, None, None, None, None, None, None, None, None),\n",
       " (75, 'Arbois', 11, 1976, None, None, None, None, None, None, None, None),\n",
       " (76, 'Chateau Chalon', 12, 1976, None, None, None, None, None, None, None, None),\n",
       " (77, 'Etoile', 11, 1979, None, None, None, None, None, None, None, None),\n",
       " (88, 'Cotes de Provence', 10, 1976, None, None, None, None, None, None, None, None),\n",
       " (89, 'Cotes de Provence', 11, 1969, None, None, None, None, None, None, None, None),\n",
       " (90, 'Palette', 11, 1969, None, None, None, None, None, None, None, None),\n",
       " (91, 'Cassis', 11, 1979, None, None, None, None, None, None, None, None),\n",
       " (92, 'Coteaux de Pierevert', None, 1967, None, None, None, None, None, None, None, None),\n",
       " (93, 'Blanquette de Limoux', None, 1978, None, None, None, None, None, None, None, None),\n",
       " (94, 'Cotes du Rousillon', None, 1978, None, None, None, None, None, None, None, None),\n",
       " (95, 'Cotes du Rousillon', 12, 1978, None, None, None, None, None, None, None, None),\n",
       " (96, 'Saint Chinian', 11, 1976, None, None, None, None, None, None, None, None),\n",
       " (97, 'Saint Chinian', 11, 1976, None, None, None, None, None, None, None, None),\n",
       " (98, 'Corbieres', 10, 1978, None, None, None, None, None, None, None, None),\n",
       " (99, 'Cote Rotie', 13, 1994, None, None, None, None, None, None, None, None),\n",
       " (101, 'Saint Veran', 12.5, 1973, None, None, None, None, None, None, None, None),\n",
       " (107, 'Sancerre', 14, 1998, None, None, None, None, None, None, None, None),\n",
       " (1, 'Mercurey', 11.5, 1980, '1977-11-02', 'BORDEAUX', 33, 2, 'Artaud', 'Antonin', 'moyen', ' NOUVELLE-AQUITAINE'),\n",
       " (10, 'Beaujolais Villages', 11.8, 1979, '1977-12-31', 'BORDEAUX', 10, 3, 'Aron', 'Raymond', 'gros', ' NOUVELLE-AQUITAINE'),\n",
       " (38, 'Savigny les Beaunes', 11, 1977, '1981-08-06', 'CAEN', 5, 12, 'Bataille', 'Georges', 'moyen', ' NORMANDIE'),\n",
       " (38, 'Savigny les Beaunes', 11, 1977, '1981-05-12', 'CAEN', 2, 14, 'Bory', 'Jean Louis', 'gros', ' NORMANDIE'),\n",
       " (100, 'Seyssel', 11, 1974, '1983-02-21', 'CAEN', 3, 5, 'Audiberti', 'Jacques', 'petit', ' NORMANDIE'),\n",
       " (7, 'Grands Echezeaux', 11.7, 1968, '1987-04-28', 'CANNES', 7, 58, 'Marivaux', 'Pierre Carlet de Chamblain de', 'gros', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (21, 'Cotes de Nuits', None, 1978, '1987-04-05', 'CANNES', 21, 62, 'Proust', 'Marcel', 'moyen', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (100, 'Seyssel', 11, 1974, '1982-11-04', 'CANNES', 10, 41, 'Gauthier', 'Theophile', 'petit', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (10, 'Beaujolais Villages', 11.8, 1979, '1982-10-30', 'CHALON SUR SAONE', 500, 2, 'Artaud', 'Antonin', 'moyen', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (40, 'Richebourg', 12, 1943, '1982-04-02', 'DIJON', 25, 17, 'Camus', 'Albert', 'petit', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (40, 'Richebourg', 12, 1943, '1980-12-31', 'DIJON', 12, 19, 'Ciceron', None, 'gros', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (24, 'Cotes de Beaune Villages', 12.1, 1971, '1986-06-12', 'LE CHESNAY', 14, 100, 'Woolf', 'Virginia', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (40, 'Richebourg', 12, 1943, '1986-08-10', 'LE CHESNAY', 4, 92, 'Verne', 'Jules', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (5, 'Pommard', 11.7, 1976, '1983-06-29', 'LILLE', 5, 52, 'Carroll', 'Lewis', 'petit', ' HAUTS-DE-FRANCE'),\n",
       " (8, 'Cotes de Beaune Villages', 12.3, 1975, '1979-11-01', 'LILLE', 10, 9, 'Ajar', 'Emile', 'petit', ' HAUTS-DE-FRANCE'),\n",
       " (9, 'Chapelle Chambertin', 11.9, 1973, '1979-05-12', 'LILLE', 1, 10, 'Andersen', 'Yann', 'gros', ' HAUTS-DE-FRANCE'),\n",
       " (2, 'Julienas', 11.3, 1974, '1983-12-25', 'LYON', 2, 48, 'Hardy', 'Thomas', 'moyen', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (9, 'Chapelle Chambertin', 11.9, 1973, '1982-03-26', 'LYON', 20, 5, 'Audiberti', 'Jacques', 'petit', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (10, 'Beaujolais Villages', 11.8, 1979, '1983-06-06', 'LYON', 10, 5, 'Audiberti', 'Jacques', 'petit', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (31, 'Monthelie', 11.4, 1968, '1984-12-31', 'LYON', 6, 26, 'Diderot', 'Denis', 'moyen', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (31, 'Monthelie', 11.4, 1968, '1978-12-25', 'LYON', 100, 28, 'Dostoievsky', 'Fiodor', 'gros', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (35, 'Auxey Duresses', 11.3, 1914, '1981-12-25', 'LYON', 80, 30, 'La Fontaine', 'Jean de', 'petit', '  AUVERGNE-RHÔNE-ALPES'),\n",
       " (3, 'Savigny les Beaunes', 12.1, 1978, '1987-12-24', 'MERCUREY', 5, 49, 'Kafka', 'Franz', 'petit', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (5, 'Pommard', 11.7, 1976, '1984-11-04', 'MERCUREY', 50, 2, 'Artaud', 'Antonin', 'moyen', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (6, 'Mercurey', 11.2, 1981, '1978-01-21', 'NANCY', 36, 3, 'Aron', 'Raymond', 'gros', ' GRAND EST'),\n",
       " (100, 'Seyssel', 11, 1974, '1982-11-05', 'NANCY', 11, 40, 'Moliere', None, 'petit', ' GRAND EST'),\n",
       " (3, 'Savigny les Beaunes', 12.1, 1978, '1978-11-01', 'NICE', 6, 7, 'Anouilh', 'Jean', 'moyen', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (20, 'Cote de Brouilly', 12.1, 1980, '1978-06-12', 'NICE', 20, 61, 'Mallarme', 'Stephane', 'petit', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (40, 'Richebourg', 12, 1943, '1982-03-25', 'NICE', 30, 15, 'Baudelaire', 'Charles', 'petit', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (1, 'Mercurey', 11.5, 1980, '2015-10-16', 'PARIS', 1, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (4, 'Mercurey', 10.9, 1980, '2015-10-16', 'PARIS', 6, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (7, 'Grands Echezeaux', 11.7, 1968, '1987-09-19', 'PARIS', 24, 4, 'Apollinaire', 'Guillaume', 'moyen', ' ÎLE-DE-FRANCE'),\n",
       " (8, 'Cotes de Beaune Villages', 12.3, 1975, '1982-09-15', 'PARIS', 78, 1, 'Aristote', None, 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (16, 'Meursault', 12.1, 1980, '2015-10-16', 'PARIS', 2, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (20, 'Cote de Brouilly', 12.1, 1980, '2015-10-16', 'PARIS', 3, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (26, 'Chateau Corton Grancey', None, 1980, '2015-10-16', 'PARIS', 4, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (28, 'Volnay', 11, 1980, '2015-10-16', 'PARIS', 5, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (32, 'Pouilly Vinzelles', 12.3, 1968, '1983-02-14', 'PARIS', 3, 22, 'Cocteau', 'Jean', 'gros', ' ÎLE-DE-FRANCE'),\n",
       " (32, 'Pouilly Vinzelles', 12.3, 1968, '1980-12-31', 'PARIS', 7, 24, 'Courrier', 'Paul Louis', 'moyen', ' ÎLE-DE-FRANCE'),\n",
       " (42, 'Beaujolais Primeur', 12, 1983, '1983-03-10', 'PARIS', 4, 100, 'Woolf', 'Virginia', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (43, 'Fleurie', 11.4, 1980, '2015-10-16', 'PARIS', 7, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (50, 'Chenas', 11.5, 1984, '1988-02-23', 'PARIS', 1, 38, 'Montaigne', 'Michel de', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (62, 'Gigondas', 11, 1978, '1980-12-21', 'PARIS', 5, 96, 'Wilde', 'Oscar', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (63, 'Coteaux du Tricastin', 10, 1978, '1982-02-02', 'PARIS', 12, 3, 'Aron', 'Raymond', 'gros', ' ÎLE-DE-FRANCE'),\n",
       " (64, 'Coteaux du Tricastin', 11, 1974, '1983-12-31', 'PARIS', 1, 97, 'Vigny', 'Alfred de', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (74, 'Arbois', 12, 1980, '2015-10-16', 'PARIS', 8, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (78, 'Etoile', 12, 1980, '2015-10-16', 'PARIS', 9, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (79, 'Seyssel', 11, 1980, '2015-10-16', 'PARIS', 10, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (80, 'Seyssel', 11, 1980, '2015-10-16', 'PARIS', 11, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (81, 'Cornas', 11.1, 1980, '2015-10-16', 'PARIS', 12, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (82, 'Cornas', 11, 1980, '2015-10-16', 'PARIS', 13, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (83, 'Saint Amour', 10, 1980, '2015-10-16', 'PARIS', 14, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (84, 'Rasteau', 10, 1980, '2015-10-16', 'PARIS', 15, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (85, 'Tavel', 11, 1980, '2015-10-16', 'PARIS', 16, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (86, 'Tavel', 11, 1980, '2015-10-16', 'PARIS', 17, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (87, 'Cotes de Provence', None, 1980, '2015-10-16', 'PARIS', 18, 44, 'Gide', 'Andre', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (22, 'Savigny les Beaunes', None, 1974, '1987-12-24', 'PARLY', 22, 80, 'Sand', 'Georges', 'petit', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (23, 'Pommard', None, 1972, '1988-03-20', 'PARLY', 23, 82, 'Roussel', 'Rene', 'petit', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (1, 'Mercurey', 11.5, 1980, '1983-12-31', 'RENNES', 1, 45, 'Giono', 'Jean', 'petit', ' BRETAGNE'),\n",
       " (22, 'Savigny les Beaunes', None, 1974, '1985-05-23', 'ROCQUENCOURT', 22, 75, 'Ronsard', 'Pierre', 'moyen', ' ÎLE-DE-FRANCE'),\n",
       " (53, 'Beaujolais Villages', None, 1975, '1983-06-06', 'ROCQUENCOURT', 10, 12, 'Bataille', 'Georges', 'moyen', ' ÎLE-DE-FRANCE'),\n",
       " (54, 'Beaujolais Villages', 10.5, 1976, '1983-05-05', 'ROCQUENCOURT', 120, 8, 'Aragon', 'Louis', 'gros', ' ÎLE-DE-FRANCE'),\n",
       " (55, 'Beaujolais Villages', 12.1, 1978, '1983-05-05', 'ROCQUENCOURT', 130, 9, 'Ajar', 'Emile', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (56, 'Saint Amour', None, 1974, '1983-05-05', 'ROCQUENCOURT', 80, 5, 'Audiberti', 'Jacques', 'petit', ' ÎLE-DE-FRANCE'),\n",
       " (4, 'Mercurey', 10.9, 1980, '1981-06-29', 'SENS', 4, 50, 'Lautreamont', None, 'moyen', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (41, 'Clairette de Die', 12, 1976, '1985-12-29', 'SENS', 3, 94, 'Zola', 'Emile', 'moyen', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (42, 'Beaujolais Primeur', 12, 1983, '1985-07-27', 'SENS', 3, 94, 'Zola', 'Emile', 'moyen', ' BOURGOGNE-FRANCHE-COMTÉ'),\n",
       " (8, 'Cotes de Beaune Villages', 12.3, 1975, '1980-05-12', 'TOULON', 8, 60, 'Ovide', None, 'gros', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (9, 'Chapelle Chambertin', 11.9, 1973, '1907-04-21', 'TOULON', 9, 61, 'Mallarme', 'Stephane', 'petit', \" PROVENCE-ALPES-CÔTE D'AZUR\"),\n",
       " (4, 'Mercurey', 10.9, 1980, '1982-11-05', 'TOULOUSE', 12, 8, 'Aragon', 'Louis', 'gros', ' OCCITANIE'),\n",
       " (12, 'Gentil', 10.7, 1975, '1982-11-05', 'TOULOUSE', 36, 6, 'Arrabal', 'Fernando', 'gros', ' OCCITANIE'),\n",
       " (40, 'Richebourg', 12, 1943, '1982-04-01', 'TOULOUSE', 1, 33, 'Flaubert', 'Gustave', 'moyen', ' OCCITANIE'),\n",
       " (41, 'Clairette de Die', 12, 1976, '1988-04-01', 'TOULOUSE', 2, 31, 'Dante', None, 'gros', ' OCCITANIE')]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT * FROM Master2 ORDER BY lieu;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Notice that Jupyter *displays* 'None' instead of 'NULL'. \n",
    "  - This is only to comply with python notation.\n",
    "* To account for NULL values, your SQL queries must test explicitly for 'NULL'.\n",
    "\n",
    "Another problem in **Master1** and **Master2** is data redundancy, for example:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NV</th>\n",
       "        <th>CRU</th>\n",
       "        <th>DEGRE</th>\n",
       "        <th>MILL</th>\n",
       "        <th>QTE</th>\n",
       "        <th>NP</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "        <th>REGION</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>90</td>\n",
       "        <td>2</td>\n",
       "        <td>Boxler</td>\n",
       "        <td>Albert</td>\n",
       "        <td>Alsace</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>912</td>\n",
       "        <td>67</td>\n",
       "        <td>Descombes</td>\n",
       "        <td>Jean Ernest</td>\n",
       "        <td>Beaujolais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>98</td>\n",
       "        <td>71</td>\n",
       "        <td>Chalandard</td>\n",
       "        <td>Danile</td>\n",
       "        <td>Jura</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>540</td>\n",
       "        <td>78</td>\n",
       "        <td>Michlel</td>\n",
       "        <td>Pierre Emile</td>\n",
       "        <td>Jura</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Chiroubles</td>\n",
       "        <td>None</td>\n",
       "        <td>1983</td>\n",
       "        <td>450</td>\n",
       "        <td>86</td>\n",
       "        <td>Dumazet</td>\n",
       "        <td>Marc</td>\n",
       "        <td>Rhone</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(45, 'Chiroubles', None, 1983, 90, 2, 'Boxler', 'Albert', 'Alsace'),\n",
       " (45, 'Chiroubles', None, 1983, 912, 67, 'Descombes', 'Jean Ernest', 'Beaujolais'),\n",
       " (45, 'Chiroubles', None, 1983, 98, 71, 'Chalandard', 'Danile', 'Jura'),\n",
       " (45, 'Chiroubles', None, 1983, 540, 78, 'Michlel', 'Pierre Emile', 'Jura'),\n",
       " (45, 'Chiroubles', None, 1983, 450, 86, 'Dumazet', 'Marc', 'Rhone')]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql SELECT *\n",
    "FROM Master1\n",
    "WHERE nv=45;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "Additional resource for Normalization:\n",
    "\n",
    "https://www.youtube.com/watch?v=UrYLYV7WSHM\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 1.1\n",
    "\n",
    "Convert table **Master1** to the Second Normal Form (2NF) or Third Normal Form (3NF) as applicable.\n",
    "* Explain your answer\n",
    "* List main functional dependencies (not all of them)\n",
    "* Describe the schema of new tables and how they relate\n",
    "  * You can write Tables as above or you can insert images in the notebook.\n",
    "  \n",
    "Remember that **`wine.db`** contains information related to wine 'production' and 'sells'.\n",
    "\n",
    "> Production <---> Wine <---> Sales\n",
    "\n",
    "A good start point is to look for the 'Wine' attributes.\n",
    "\n",
    "**Hint:** Look for redundant information between the master tables."
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "MASTER1\n",
    "Functional dependencies : \n",
    "\n",
    "NV -> {CRU,DEGRE,MILL}\n",
    "NP -> {NOM,PRENOM,REGION}\n",
    "NP,NV -> {CRU,DEGRE,MILL,QTE,NOM,PRENOM,REGION}\n",
    "\n",
    "To convert Master1 to 2NF,  we have to check that the relationship is in 1NF (it is the case) and that there are no partial dependencies.\n",
    "\n",
    "We create the new tables:\n",
    "subtable1: NP,NOM,PRENOM\n",
    "subtable2: NV,CRU,DEGRE,MILL\n",
    "subtable3: NP,NV,QTE,REGION\n",
    "The subtables1 and 2 are joined on subtable 3 by NP and NV respectively. Each subtable has no partial dependencies.\n",
    "We have created a 2NF crelation.\n",
    "It is also 3NF.\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 1.2\n",
    "\n",
    "Convert table **Master2** to the Second Normal Form (2NF) or Third Normal Form (3NF) as applicable.\n",
    "* Explain your answer\n",
    "* List main functional dependencies (not all of them)\n",
    "* Describe the schema of new tables and how they relate\n",
    "  * You can write Tables as above or you can insert images in the notebook.\n",
    "\n",
    "**Note:** For this part, consider that a wine can be bought in multiple locations and multiple times per day."
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "MASTER2\n",
    "Functional dependencies :\n",
    "\n",
    "NB -> {NOM,PRENOM,TYPE}\n",
    "NV -> {CRU,DEGRE,MILL}\n",
    "LIEU -> {REGION}\n",
    "NB,NV,LIEU -> {NV,CRU,DEGRE,MILL,DATES,LIEU,QTE,NB,NOM,PRENOM,TYPE,REGION}\n",
    "\n",
    "We create the new subtables to define a 2NF relation:\n",
    "subtable1 : NB,NOM,PRENOM,TYPE where key is NB\n",
    "subtable2: NV,CRU,DEGRE,MILL where key is NV\n",
    "subtable3: LIEU,REGION where key is LIEU\n",
    "subtable4:NB,NV,LIEU,QTE,DATES where key is NB,NV,LIEU"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Once you have defined the 2NF or 3NF (as applicable) we need to split the data into new tables.\n",
    "\n",
    "A table can be created from the result of a query.\n",
    "\n",
    "In the following example we will create a new table \"dummy\" to store the different values of alcohol content."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql DROP TABLE IF EXISTS dummy;\n",
    "\n",
    "-- Create dummy table\n",
    "CREATE TABLE dummy AS\n",
    "SELECT DISTINCT DEGRE\n",
    "FROM MASTER1;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Content of the database\n",
      "MASTER1:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "  4: QTE(NUM)\n",
      "  5: NP(NUM)\n",
      "  6: NOM(TEXT)\n",
      "  7: PRENOM(TEXT)\n",
      "  8: REGION(TEXT)\n",
      "MASTER1sub1:\n",
      "  0: NP(NUM)\n",
      "  1: NOM(TEXT)\n",
      "  2: PRENOM(TEXT)\n",
      "  3: REGION(TEXT)\n",
      "MASTER1sub2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "MASTER1sub3:\n",
      "  0: NP(NUM)\n",
      "  1: NV(NUM)\n",
      "  2: QTE(NUM)\n",
      "MASTER2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "  4: DATES(DATE)\n",
      "  5: LIEU(TEXT)\n",
      "  6: QTE(NUM)\n",
      "  7: NB(NUM)\n",
      "  8: NOM(TEXT)\n",
      "  9: PRENOM(TEXT)\n",
      "  10: TYPE(TEXT)\n",
      "  11: REGION(TEXT)\n",
      "MASTER2sub1:\n",
      "  0: NB(NUM)\n",
      "  1: NOM(TEXT)\n",
      "  2: PRENOM(TEXT)\n",
      "  3: TYPE(TEXT)\n",
      "MASTER2sub2:\n",
      "  0: NV(NUM)\n",
      "  1: CRU(TEXT)\n",
      "  2: DEGRE(NUM)\n",
      "  3: MILL(NUM)\n",
      "MASTER2sub3:\n",
      "  0: LIEU(TEXT)\n",
      "  1: REGION(TEXT)\n",
      "MASTER2sub4:\n",
      "  0: NB(NUM)\n",
      "  1: NV(NUM)\n",
      "  2: LIEU(TEXT)\n",
      "  3: QTE(NUM)\n",
      "  4: DATES(NUM)\n",
      "dummy:\n",
      "  0: DEGRE(NUM)\n"
     ]
    }
   ],
   "source": [
    "print(\"\\nContent of the database\")\n",
    "printSchema(conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>DEGRE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(None,),\n",
       " (11.5,),\n",
       " (11.3,),\n",
       " (12.1,),\n",
       " (10.9,),\n",
       " (11.7,),\n",
       " (11.2,),\n",
       " (12.3,),\n",
       " (11.9,),\n",
       " (11.8,),\n",
       " (10.7,),\n",
       " (11.4,),\n",
       " (10.5,),\n",
       " (11,),\n",
       " (11.6,),\n",
       " (12,),\n",
       " (10,),\n",
       " (12.5,),\n",
       " (10.8,),\n",
       " (14,),\n",
       " (11.1,),\n",
       " (13,)]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT *\n",
    "FROM dummy;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Looking into \"dummy\", we notice that our query includes NULL. This is not allowed if we were to use DEGRE as key for a table.\n",
    "\n",
    "To correct this, we need to change the query to explicitly test for NULL as follows:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n",
      "Done.\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>DEGRE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(11.5,),\n",
       " (11.3,),\n",
       " (12.1,),\n",
       " (10.9,),\n",
       " (11.7,),\n",
       " (11.2,),\n",
       " (12.3,),\n",
       " (11.9,),\n",
       " (11.8,),\n",
       " (10.7,),\n",
       " (11.4,),\n",
       " (10.5,),\n",
       " (11,),\n",
       " (11.6,),\n",
       " (12,),\n",
       " (10,),\n",
       " (12.5,),\n",
       " (10.8,),\n",
       " (14,),\n",
       " (11.1,),\n",
       " (13,)]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql DROP TABLE IF EXISTS dummy;\n",
    "\n",
    "-- Create dummy table\n",
    "CREATE TABLE dummy AS\n",
    "SELECT DISTINCT DEGRE\n",
    "FROM MASTER1\n",
    "WHERE DEGRE IS NOT NULL;\n",
    "\n",
    "SELECT *\n",
    "FROM dummy;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Notice that we use `NULL` given that `None` is only used for display."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 1.3\n",
    "\n",
    "Create the new tables from Master1:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n",
      "Done.\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "-- Create first subtable of master 1\n",
    "CREATE TABLE MASTER1sub1 AS\n",
    "SELECT DISTINCT NP,NOM,PRENOM\n",
    "FROM MASTER1\n",
    "WHERE NP IS NOT NULL;\n",
    "\n",
    "-- Create second subtable of master 1\n",
    "CREATE TABLE MASTER1sub2 AS\n",
    "SELECT DISTINCT NV,CRU,DEGRE,MILL\n",
    "FROM MASTER1\n",
    "WHERE NV IS NOT NULL;\n",
    "\n",
    "\n",
    "-- Create third subtable of master 1\n",
    "CREATE TABLE MASTER1sub3 AS\n",
    "SELECT DISTINCT NP,NV,QTE,REGION\n",
    "FROM MASTER1\n",
    "WHERE NP IS NOT NULL AND NV IS NOT NULL;\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 1.4\n",
    "\n",
    "Create the new tables from Master2:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "(sqlite3.OperationalError) table MASTER2sub1 already exists [SQL: '-- Create first subtable of master 2\\nCREATE TABLE MASTER2sub1 AS\\nSELECT DISTINCT NB,NOM,PRENOM,TYPE\\nFROM MASTER2\\nWHERE NB IS NOT NULL;'] (Background on this error at: http://sqlalche.me/e/e3q8)\n"
     ]
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "-- Create first subtable of master 2\n",
    "CREATE TABLE MASTER2sub1 AS\n",
    "SELECT DISTINCT NB,NOM,PRENOM,TYPE\n",
    "FROM MASTER2\n",
    "WHERE NB IS NOT NULL;\n",
    "\n",
    "-- Create second subtable of master 2\n",
    "CREATE TABLE MASTER2sub2 AS\n",
    "SELECT DISTINCT NV,CRU,DEGRE,MILL\n",
    "FROM MASTER2\n",
    "WHERE NV IS NOT NULL;\n",
    "\n",
    "\n",
    "-- Create third subtable of master 2\n",
    "CREATE TABLE MASTER2sub3 AS\n",
    "SELECT DISTINCT LIEU,REGION\n",
    "FROM MASTER2\n",
    "WHERE LIEU IS NOT NULL;\n",
    "\n",
    "-- Create fourth subtable of master 2\n",
    "CREATE TABLE MASTER2sub4 AS\n",
    "SELECT DISTINCT NB,NV,LIEU,QTE,DATES\n",
    "FROM MASTER2\n",
    "WHERE NB IS NOT NULL AND NV IS NOT NULL AND LIEU IS NOT NULL;\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PART II: SQL QUERIES\n",
    "\n",
    "In the second part of this TP you will create SQL queries to retrieve information from the database.\n",
    "\n",
    "**Important:**\n",
    "\n",
    "- You MUST use the normalized tables created in previous steps.\n",
    "  - The normalized tables will also be used in TP3.\n",
    "- Do NOT use **Master1** and **Master2** in your queries."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.1\n",
    "\n",
    "What are the different types of clients (buveurs) by volume of purchases?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>TYPE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>petit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>moyen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>gros</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('petit',), ('moyen',), ('gros',)]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT DISTINCT TYPE\n",
    "FROM MASTER2sub1;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.2\n",
    "\n",
    "What regions produce Pommard or Brouilly?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>CRU</th>\n",
       "        <th>REGION</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pommard</td>\n",
       "        <td>Bourgogne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Pommard</td>\n",
       "        <td>Rhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Brouilly</td>\n",
       "        <td>Bourgogne</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Pommard', 'Bourgogne'), ('Pommard', 'Rhone'), ('Brouilly', 'Bourgogne')]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "SELECT REGION\n",
    "FROM MASTER1sub2 NATURAL JOIN MASTER1sub3\n",
    "WHERE CRU = 'Pommard' OR CRU = 'Brouilly';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.3\n",
    "\n",
    "What regions produce Pommard and Brouilly?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>REGION</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Bourgogne</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Bourgogne',)]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "SELECT REGION\n",
    "FROM MASTER1sub2 NATURAL JOIN MASTER1sub3\n",
    "WHERE CRU = 'Pommard' INTERSECT \n",
    "SELECT REGION\n",
    "FROM MASTER1sub2 NATURAL JOIN MASTER1sub3\n",
    "WHERE CRU = 'Brouilly';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.4\n",
    "\n",
    "Get the number of wines bought by CRU and Millésime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>nb_of_wines_bought</th>\n",
       "        <th>CRU</th>\n",
       "        <th>MILL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Arbois</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>80</td>\n",
       "        <td>Auxey Duresses</td>\n",
       "        <td>1914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Beaujolais Primeur</td>\n",
       "        <td>1983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>1975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>120</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>1976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>130</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>500</td>\n",
       "        <td>Beaujolais Villages</td>\n",
       "        <td>1979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Chapelle Chambertin</td>\n",
       "        <td>1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Chateau Corton Grancey</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Chenas</td>\n",
       "        <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>Clairette de Die</td>\n",
       "        <td>1976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>Cornas</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Cote de Brouilly</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Coteaux du Tricastin</td>\n",
       "        <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>Coteaux du Tricastin</td>\n",
       "        <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>1971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>78</td>\n",
       "        <td>Cotes de Beaune Villages</td>\n",
       "        <td>1975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>Cotes de Nuits</td>\n",
       "        <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>Cotes de Provence</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>Etoile</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>Fleurie</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>36</td>\n",
       "        <td>Gentil</td>\n",
       "        <td>1975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Gigondas</td>\n",
       "        <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>24</td>\n",
       "        <td>Grands Echezeaux</td>\n",
       "        <td>1968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>Julienas</td>\n",
       "        <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>36</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>Meursault</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Monthelie</td>\n",
       "        <td>1968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>Pommard</td>\n",
       "        <td>1972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>50</td>\n",
       "        <td>Pommard</td>\n",
       "        <td>1976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>Pouilly Vinzelles</td>\n",
       "        <td>1968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>Rasteau</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>30</td>\n",
       "        <td>Richebourg</td>\n",
       "        <td>1943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>80</td>\n",
       "        <td>Saint Amour</td>\n",
       "        <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>Saint Amour</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>1977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>Savigny les Beaunes</td>\n",
       "        <td>1978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>Seyssel</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>Tavel</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Volnay</td>\n",
       "        <td>1980</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(8, 'Arbois', 1980),\n",
       " (80, 'Auxey Duresses', 1914),\n",
       " (4, 'Beaujolais Primeur', 1983),\n",
       " (10, 'Beaujolais Villages', 1975),\n",
       " (120, 'Beaujolais Villages', 1976),\n",
       " (130, 'Beaujolais Villages', 1978),\n",
       " (500, 'Beaujolais Villages', 1979),\n",
       " (20, 'Chapelle Chambertin', 1973),\n",
       " (4, 'Chateau Corton Grancey', 1980),\n",
       " (1, 'Chenas', 1984),\n",
       " (3, 'Clairette de Die', 1976),\n",
       " (13, 'Cornas', 1980),\n",
       " (20, 'Cote de Brouilly', 1980),\n",
       " (1, 'Coteaux du Tricastin', 1974),\n",
       " (12, 'Coteaux du Tricastin', 1978),\n",
       " (14, 'Cotes de Beaune Villages', 1971),\n",
       " (78, 'Cotes de Beaune Villages', 1975),\n",
       " (21, 'Cotes de Nuits', 1978),\n",
       " (18, 'Cotes de Provence', 1980),\n",
       " (9, 'Etoile', 1980),\n",
       " (7, 'Fleurie', 1980),\n",
       " (36, 'Gentil', 1975),\n",
       " (5, 'Gigondas', 1978),\n",
       " (24, 'Grands Echezeaux', 1968),\n",
       " (2, 'Julienas', 1974),\n",
       " (12, 'Mercurey', 1980),\n",
       " (36, 'Mercurey', 1981),\n",
       " (2, 'Meursault', 1980),\n",
       " (100, 'Monthelie', 1968),\n",
       " (23, 'Pommard', 1972),\n",
       " (50, 'Pommard', 1976),\n",
       " (7, 'Pouilly Vinzelles', 1968),\n",
       " (15, 'Rasteau', 1980),\n",
       " (30, 'Richebourg', 1943),\n",
       " (80, 'Saint Amour', 1974),\n",
       " (14, 'Saint Amour', 1980),\n",
       " (22, 'Savigny les Beaunes', 1974),\n",
       " (5, 'Savigny les Beaunes', 1977),\n",
       " (6, 'Savigny les Beaunes', 1978),\n",
       " (11, 'Seyssel', 1974),\n",
       " (11, 'Seyssel', 1980),\n",
       " (17, 'Tavel', 1980),\n",
       " (5, 'Volnay', 1980)]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "SELECT QTE AS nb_of_wines_bought,CRU, MILL\n",
    "FROM MASTER2sub2\n",
    "NATURAL JOIN MASTER2sub4\n",
    "GROUP BY CRU,MILL;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.5\n",
    "\n",
    "Retrieve the wine number (NV) of wines produced by more than three producers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NV</th>\n",
       "        <th>COUNT(DISTINCT(NP))</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>78</td>\n",
       "        <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>89</td>\n",
       "        <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>98</td>\n",
       "        <td>5</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(45, 5), (78, 5), (89, 4), (98, 5)]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "SELECT NV, COUNT(DISTINCT(NP)) AS number_of_producers\n",
    "FROM MASTER1sub3 NATURAL JOIN MASTER1sub1 NATURAL JOIN MASTER1sub2\n",
    "GROUP BY NV\n",
    "HAVING COUNT(DISTINCT(NP))>3\n",
    ";"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.6\n",
    "\n",
    "Which producers have not produced any wine?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NP</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>Six</td>\n",
       "        <td>Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>Marmagne</td>\n",
       "        <td>Bernard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Lioger d&#x27;Harduy</td>\n",
       "        <td>Gabriel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>Barbin</td>\n",
       "        <td>Bernard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>Faiveley</td>\n",
       "        <td>Guy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>Tramier</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>Dupaquier</td>\n",
       "        <td>Roger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Lamy</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>Cornu</td>\n",
       "        <td>Edmond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>26</td>\n",
       "        <td>Violot</td>\n",
       "        <td>Gilbert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>28</td>\n",
       "        <td>Monnier</td>\n",
       "        <td>Rene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>29</td>\n",
       "        <td>de Suremain</td>\n",
       "        <td>Robert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>Prudhon</td>\n",
       "        <td>Henri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>32</td>\n",
       "        <td>Mestre</td>\n",
       "        <td>Philippe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>33</td>\n",
       "        <td>Prieur</td>\n",
       "        <td>Guy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>34</td>\n",
       "        <td>Monnier</td>\n",
       "        <td>Rene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>37</td>\n",
       "        <td>Delagrange Bachelet</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>39</td>\n",
       "        <td>de Suremin</td>\n",
       "        <td>Hugues</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>Juillot</td>\n",
       "        <td>Michel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>44</td>\n",
       "        <td>Feyveley</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>47</td>\n",
       "        <td>Thenard</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>48</td>\n",
       "        <td>Flamand</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>49</td>\n",
       "        <td>Guillot</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>51</td>\n",
       "        <td>Simonet</td>\n",
       "        <td>Leon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>53</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>57</td>\n",
       "        <td>Desmules</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>58</td>\n",
       "        <td>Joubert</td>\n",
       "        <td>Claude</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>61</td>\n",
       "        <td>Champier</td>\n",
       "        <td>Charles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>62</td>\n",
       "        <td>Champagnon</td>\n",
       "        <td>Louis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>66</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>77</td>\n",
       "        <td>Tissot</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>83</td>\n",
       "        <td>Goy</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>91</td>\n",
       "        <td>Chave</td>\n",
       "        <td>Gerard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>92</td>\n",
       "        <td>De Boissieu</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>94</td>\n",
       "        <td>Grippat</td>\n",
       "        <td>Jean Louis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>96</td>\n",
       "        <td>Boisson</td>\n",
       "        <td>Jean Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>97</td>\n",
       "        <td>Quiot</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Bernard</td>\n",
       "        <td>Georges</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>101</td>\n",
       "        <td>Verdan</td>\n",
       "        <td>Antoine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>102</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>103</td>\n",
       "        <td>Coulouvrat</td>\n",
       "        <td>Michel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>104</td>\n",
       "        <td>Rabasse Chavarin</td>\n",
       "        <td>Abel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>105</td>\n",
       "        <td>Roux</td>\n",
       "        <td>Charles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>106</td>\n",
       "        <td>Alary</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>108</td>\n",
       "        <td>Archimbaud</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>109</td>\n",
       "        <td>Rey</td>\n",
       "        <td>Marcel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>110</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>111</td>\n",
       "        <td>Zafiropulo</td>\n",
       "        <td>Costa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>112</td>\n",
       "        <td>Prebost</td>\n",
       "        <td>Gaston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>113</td>\n",
       "        <td>Gomez</td>\n",
       "        <td>Rene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>114</td>\n",
       "        <td>Brunet</td>\n",
       "        <td>Georges</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>115</td>\n",
       "        <td>Bordonado</td>\n",
       "        <td>Raymond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>116</td>\n",
       "        <td>Imbert</td>\n",
       "        <td>Christian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>117</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>118</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>119</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>121</td>\n",
       "        <td>Cooperative</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>122</td>\n",
       "        <td>Dupuy</td>\n",
       "        <td>Charles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>123</td>\n",
       "        <td>Laurent</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>124</td>\n",
       "        <td>Daurat Fort</td>\n",
       "        <td>Robert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>125</td>\n",
       "        <td>Baldes</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>126</td>\n",
       "        <td>Jouffreau</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>127</td>\n",
       "        <td>Brumont</td>\n",
       "        <td>Alban</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>129</td>\n",
       "        <td>Barrere</td>\n",
       "        <td>Alfred</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(3, 'Six', 'Paul'),\n",
       " (6, 'Marmagne', 'Bernard'),\n",
       " (8, \"Lioger d'Harduy\", 'Gabriel'),\n",
       " (16, 'Barbin', 'Bernard'),\n",
       " (17, 'Faiveley', 'Guy'),\n",
       " (18, 'Tramier', 'Jean'),\n",
       " (19, 'Dupaquier', 'Roger'),\n",
       " (20, 'Lamy', 'Jean'),\n",
       " (21, 'Cornu', 'Edmond'),\n",
       " (26, 'Violot', 'Gilbert'),\n",
       " (28, 'Monnier', 'Rene'),\n",
       " (29, 'de Suremain', 'Robert'),\n",
       " (31, 'Prudhon', 'Henri'),\n",
       " (32, 'Mestre', 'Philippe'),\n",
       " (33, 'Prieur', 'Guy'),\n",
       " (34, 'Monnier', 'Rene'),\n",
       " (37, 'Delagrange Bachelet', None),\n",
       " (39, 'de Suremin', 'Hugues'),\n",
       " (41, 'Juillot', 'Michel'),\n",
       " (44, 'Feyveley', None),\n",
       " (47, 'Thenard', None),\n",
       " (48, 'Flamand', None),\n",
       " (49, 'Guillot', 'Pierre'),\n",
       " (51, 'Simonet', 'Leon'),\n",
       " (53, 'Cooperative', None),\n",
       " (57, 'Desmules', 'Pierre'),\n",
       " (58, 'Joubert', 'Claude'),\n",
       " (61, 'Champier', 'Charles'),\n",
       " (62, 'Champagnon', 'Louis'),\n",
       " (66, 'Cooperative', None),\n",
       " (77, 'Tissot', 'Andre'),\n",
       " (83, 'Goy', None),\n",
       " (91, 'Chave', 'Gerard'),\n",
       " (92, 'De Boissieu', None),\n",
       " (94, 'Grippat', 'Jean Louis'),\n",
       " (96, 'Boisson', 'Jean Pierre'),\n",
       " (97, 'Quiot', 'Pierre'),\n",
       " (100, 'Bernard', 'Georges'),\n",
       " (101, 'Verdan', 'Antoine'),\n",
       " (102, 'Cooperative', None),\n",
       " (103, 'Coulouvrat', 'Michel'),\n",
       " (104, 'Rabasse Chavarin', 'Abel'),\n",
       " (105, 'Roux', 'Charles'),\n",
       " (106, 'Alary', None),\n",
       " (108, 'Archimbaud', 'Jean'),\n",
       " (109, 'Rey', 'Marcel'),\n",
       " (110, 'Cooperative', None),\n",
       " (111, 'Zafiropulo', 'Costa'),\n",
       " (112, 'Prebost', 'Gaston'),\n",
       " (113, 'Gomez', 'Rene'),\n",
       " (114, 'Brunet', 'Georges'),\n",
       " (115, 'Bordonado', 'Raymond'),\n",
       " (116, 'Imbert', 'Christian'),\n",
       " (117, 'Cooperative', None),\n",
       " (118, 'Cooperative', None),\n",
       " (119, 'Cooperative', None),\n",
       " (121, 'Cooperative', None),\n",
       " (122, 'Dupuy', 'Charles'),\n",
       " (123, 'Laurent', 'Pierre'),\n",
       " (124, 'Daurat Fort', 'Robert'),\n",
       " (125, 'Baldes', 'Jean'),\n",
       " (126, 'Jouffreau', 'Jean'),\n",
       " (127, 'Brumont', 'Alban'),\n",
       " (129, 'Barrere', 'Alfred')]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT NP,NOM,PRENOM FROM MASTER1sub1\n",
    "WHERE NP IN (\n",
    "SELECT NP\n",
    "FROM MASTER1sub1\n",
    "EXCEPT \n",
    "SELECT NP\n",
    "FROM MASTER1sub3)\n",
    ";"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.7\n",
    "\n",
    "What clients (buveurs) have bought at least one wine from 1980?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NB</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>Artaud</td>\n",
       "        <td>Antonin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>Aragon</td>\n",
       "        <td>Louis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Giono</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>50</td>\n",
       "        <td>Lautreamont</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>61</td>\n",
       "        <td>Mallarme</td>\n",
       "        <td>Stephane</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 'Artaud', 'Antonin'),\n",
       " (8, 'Aragon', 'Louis'),\n",
       " (44, 'Gide', 'Andre'),\n",
       " (45, 'Giono', 'Jean'),\n",
       " (50, 'Lautreamont', None),\n",
       " (61, 'Mallarme', 'Stephane')]"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT NB,NOM,PRENOM\n",
    "FROM MASTER2sub1\n",
    "NATURAL JOIN MASTER2sub4\n",
    "NATURAL JOIN MASTER2sub2\n",
    "WHERE MILL = 1980\n",
    "GROUP BY NB;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.8\n",
    "\n",
    "What clients (buveurs) have NOT bought any wine from 1980?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NB</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Aristote</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>Aron</td>\n",
       "        <td>Raymond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>Apollinaire</td>\n",
       "        <td>Guillaume</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>Audiberti</td>\n",
       "        <td>Jacques</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>Arrabal</td>\n",
       "        <td>Fernando</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>Anouilh</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>Ajar</td>\n",
       "        <td>Emile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>Andersen</td>\n",
       "        <td>Yann</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>Breton</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>Bataille</td>\n",
       "        <td>Georges</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>Barthes</td>\n",
       "        <td>Roland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>Bory</td>\n",
       "        <td>Jean Louis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>Baudelaire</td>\n",
       "        <td>Charles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>Balzac</td>\n",
       "        <td>Honore de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>Camus</td>\n",
       "        <td>Albert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>Celine</td>\n",
       "        <td>Louis Ferdinand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>Ciceron</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>Chateaubriand</td>\n",
       "        <td>Francois-Rene de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>Corbiere</td>\n",
       "        <td>Tristan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>Cocteau</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>Corneille</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>24</td>\n",
       "        <td>Courrier</td>\n",
       "        <td>Paul Louis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>25</td>\n",
       "        <td>Char</td>\n",
       "        <td>Rene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>26</td>\n",
       "        <td>Diderot</td>\n",
       "        <td>Denis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>27</td>\n",
       "        <td>Dumas</td>\n",
       "        <td>Alexandre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>28</td>\n",
       "        <td>Dostoievsky</td>\n",
       "        <td>Fiodor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>29</td>\n",
       "        <td>Fournier</td>\n",
       "        <td>Alain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>30</td>\n",
       "        <td>La Fontaine</td>\n",
       "        <td>Jean de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>Dante</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>32</td>\n",
       "        <td>Eluard</td>\n",
       "        <td>Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>33</td>\n",
       "        <td>Flaubert</td>\n",
       "        <td>Gustave</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>34</td>\n",
       "        <td>Mauriac</td>\n",
       "        <td>Francois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>35</td>\n",
       "        <td>Fromentin</td>\n",
       "        <td>Eugene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>36</td>\n",
       "        <td>Maurois</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>37</td>\n",
       "        <td>Freud</td>\n",
       "        <td>Sigmund</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>38</td>\n",
       "        <td>Montaigne</td>\n",
       "        <td>Michel de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>39</td>\n",
       "        <td>Montesquieu</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>40</td>\n",
       "        <td>Moliere</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>Gauthier</td>\n",
       "        <td>Theophile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>42</td>\n",
       "        <td>Goethe</td>\n",
       "        <td>Johann Wolfgang von</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>43</td>\n",
       "        <td>Musset</td>\n",
       "        <td>Alfred de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>46</td>\n",
       "        <td>Hugo</td>\n",
       "        <td>Victor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>47</td>\n",
       "        <td>Gary</td>\n",
       "        <td>Romain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>48</td>\n",
       "        <td>Hardy</td>\n",
       "        <td>Thomas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>49</td>\n",
       "        <td>Kafka</td>\n",
       "        <td>Franz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>51</td>\n",
       "        <td>Lafargue</td>\n",
       "        <td>Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>52</td>\n",
       "        <td>Carroll</td>\n",
       "        <td>Lewis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>53</td>\n",
       "        <td>Lamartine</td>\n",
       "        <td>Alphonse de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>54</td>\n",
       "        <td>Aurele</td>\n",
       "        <td>Marc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>55</td>\n",
       "        <td>Michelet</td>\n",
       "        <td>Jules</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>56</td>\n",
       "        <td>Nerval</td>\n",
       "        <td>Gerard de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>57</td>\n",
       "        <td>Marx</td>\n",
       "        <td>Karl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>58</td>\n",
       "        <td>Marivaux</td>\n",
       "        <td>Pierre Carlet de Chamblain de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>59</td>\n",
       "        <td>Nietzsche</td>\n",
       "        <td>Friedrich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>60</td>\n",
       "        <td>Ovide</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>62</td>\n",
       "        <td>Proust</td>\n",
       "        <td>Marcel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>63</td>\n",
       "        <td>Maupassant</td>\n",
       "        <td>Guy de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>64</td>\n",
       "        <td>Platon</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>65</td>\n",
       "        <td>Pascal</td>\n",
       "        <td>Blaise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>66</td>\n",
       "        <td>Perec</td>\n",
       "        <td>Georges</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>67</td>\n",
       "        <td>Nin</td>\n",
       "        <td>Anais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>68</td>\n",
       "        <td>Prevert</td>\n",
       "        <td>Jacques</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>69</td>\n",
       "        <td>Queneau</td>\n",
       "        <td>Raymond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>70</td>\n",
       "        <td>Paulhan</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>71</td>\n",
       "        <td>Radiguet</td>\n",
       "        <td>Raymond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>72</td>\n",
       "        <td>Rabelais</td>\n",
       "        <td>Francois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>73</td>\n",
       "        <td>Poe</td>\n",
       "        <td>Allan Edgard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>74</td>\n",
       "        <td>Rimbaud</td>\n",
       "        <td>Arthur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>75</td>\n",
       "        <td>Ronsard</td>\n",
       "        <td>Pierre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>76</td>\n",
       "        <td>Racine</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>77</td>\n",
       "        <td>Rousseau</td>\n",
       "        <td>Jean-Jacques</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>78</td>\n",
       "        <td>Sandier</td>\n",
       "        <td>Jules</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>79</td>\n",
       "        <td>Sade</td>\n",
       "        <td>Donatien Alphonse Fran¿¿s de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>80</td>\n",
       "        <td>Sand</td>\n",
       "        <td>Georges</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>81</td>\n",
       "        <td>Sartre</td>\n",
       "        <td>Jean-Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>82</td>\n",
       "        <td>Roussel</td>\n",
       "        <td>Rene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>83</td>\n",
       "        <td>Sophocle</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>84</td>\n",
       "        <td>Sue</td>\n",
       "        <td>Eugene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>85</td>\n",
       "        <td>Segalen</td>\n",
       "        <td>Victor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>86</td>\n",
       "        <td>Saint Exupery</td>\n",
       "        <td>Antoine de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>87</td>\n",
       "        <td>Segur</td>\n",
       "        <td>Comtesse de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>88</td>\n",
       "        <td>Shakespeare</td>\n",
       "        <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>89</td>\n",
       "        <td>Stendhal</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>90</td>\n",
       "        <td>Vian</td>\n",
       "        <td>Boris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>91</td>\n",
       "        <td>Verlaine</td>\n",
       "        <td>Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>92</td>\n",
       "        <td>Verne</td>\n",
       "        <td>Jules</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>93</td>\n",
       "        <td>Virgile</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>94</td>\n",
       "        <td>Zola</td>\n",
       "        <td>Emile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>95</td>\n",
       "        <td>Zorn</td>\n",
       "        <td>Fritz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>96</td>\n",
       "        <td>Wilde</td>\n",
       "        <td>Oscar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>97</td>\n",
       "        <td>Vigny</td>\n",
       "        <td>Alfred de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>98</td>\n",
       "        <td>Maturin</td>\n",
       "        <td>Robert</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>99</td>\n",
       "        <td>Cesar</td>\n",
       "        <td>Jules</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>100</td>\n",
       "        <td>Woolf</td>\n",
       "        <td>Virginia</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(1, 'Aristote', None),\n",
       " (3, 'Aron', 'Raymond'),\n",
       " (4, 'Apollinaire', 'Guillaume'),\n",
       " (5, 'Audiberti', 'Jacques'),\n",
       " (6, 'Arrabal', 'Fernando'),\n",
       " (7, 'Anouilh', 'Jean'),\n",
       " (9, 'Ajar', 'Emile'),\n",
       " (10, 'Andersen', 'Yann'),\n",
       " (11, 'Breton', 'Andre'),\n",
       " (12, 'Bataille', 'Georges'),\n",
       " (13, 'Barthes', 'Roland'),\n",
       " (14, 'Bory', 'Jean Louis'),\n",
       " (15, 'Baudelaire', 'Charles'),\n",
       " (16, 'Balzac', 'Honore de'),\n",
       " (17, 'Camus', 'Albert'),\n",
       " (18, 'Celine', 'Louis Ferdinand'),\n",
       " (19, 'Ciceron', None),\n",
       " (20, 'Chateaubriand', 'Francois-Rene de'),\n",
       " (21, 'Corbiere', 'Tristan'),\n",
       " (22, 'Cocteau', 'Jean'),\n",
       " (23, 'Corneille', 'Pierre'),\n",
       " (24, 'Courrier', 'Paul Louis'),\n",
       " (25, 'Char', 'Rene'),\n",
       " (26, 'Diderot', 'Denis'),\n",
       " (27, 'Dumas', 'Alexandre'),\n",
       " (28, 'Dostoievsky', 'Fiodor'),\n",
       " (29, 'Fournier', 'Alain'),\n",
       " (30, 'La Fontaine', 'Jean de'),\n",
       " (31, 'Dante', None),\n",
       " (32, 'Eluard', 'Paul'),\n",
       " (33, 'Flaubert', 'Gustave'),\n",
       " (34, 'Mauriac', 'Francois'),\n",
       " (35, 'Fromentin', 'Eugene'),\n",
       " (36, 'Maurois', 'Andre'),\n",
       " (37, 'Freud', 'Sigmund'),\n",
       " (38, 'Montaigne', 'Michel de'),\n",
       " (39, 'Montesquieu', None),\n",
       " (40, 'Moliere', None),\n",
       " (41, 'Gauthier', 'Theophile'),\n",
       " (42, 'Goethe', 'Johann Wolfgang von'),\n",
       " (43, 'Musset', 'Alfred de'),\n",
       " (46, 'Hugo', 'Victor'),\n",
       " (47, 'Gary', 'Romain'),\n",
       " (48, 'Hardy', 'Thomas'),\n",
       " (49, 'Kafka', 'Franz'),\n",
       " (51, 'Lafargue', 'Paul'),\n",
       " (52, 'Carroll', 'Lewis'),\n",
       " (53, 'Lamartine', 'Alphonse de'),\n",
       " (54, 'Aurele', 'Marc'),\n",
       " (55, 'Michelet', 'Jules'),\n",
       " (56, 'Nerval', 'Gerard de'),\n",
       " (57, 'Marx', 'Karl'),\n",
       " (58, 'Marivaux', 'Pierre Carlet de Chamblain de'),\n",
       " (59, 'Nietzsche', 'Friedrich'),\n",
       " (60, 'Ovide', None),\n",
       " (62, 'Proust', 'Marcel'),\n",
       " (63, 'Maupassant', 'Guy de'),\n",
       " (64, 'Platon', None),\n",
       " (65, 'Pascal', 'Blaise'),\n",
       " (66, 'Perec', 'Georges'),\n",
       " (67, 'Nin', 'Anais'),\n",
       " (68, 'Prevert', 'Jacques'),\n",
       " (69, 'Queneau', 'Raymond'),\n",
       " (70, 'Paulhan', 'Jean'),\n",
       " (71, 'Radiguet', 'Raymond'),\n",
       " (72, 'Rabelais', 'Francois'),\n",
       " (73, 'Poe', 'Allan Edgard'),\n",
       " (74, 'Rimbaud', 'Arthur'),\n",
       " (75, 'Ronsard', 'Pierre'),\n",
       " (76, 'Racine', 'Jean'),\n",
       " (77, 'Rousseau', 'Jean-Jacques'),\n",
       " (78, 'Sandier', 'Jules'),\n",
       " (79, 'Sade', 'Donatien Alphonse Fran¿¿s de'),\n",
       " (80, 'Sand', 'Georges'),\n",
       " (81, 'Sartre', 'Jean-Paul'),\n",
       " (82, 'Roussel', 'Rene'),\n",
       " (83, 'Sophocle', None),\n",
       " (84, 'Sue', 'Eugene'),\n",
       " (85, 'Segalen', 'Victor'),\n",
       " (86, 'Saint Exupery', 'Antoine de'),\n",
       " (87, 'Segur', 'Comtesse de'),\n",
       " (88, 'Shakespeare', 'William'),\n",
       " (89, 'Stendhal', None),\n",
       " (90, 'Vian', 'Boris'),\n",
       " (91, 'Verlaine', 'Paul'),\n",
       " (92, 'Verne', 'Jules'),\n",
       " (93, 'Virgile', None),\n",
       " (94, 'Zola', 'Emile'),\n",
       " (95, 'Zorn', 'Fritz'),\n",
       " (96, 'Wilde', 'Oscar'),\n",
       " (97, 'Vigny', 'Alfred de'),\n",
       " (98, 'Maturin', 'Robert'),\n",
       " (99, 'Cesar', 'Jules'),\n",
       " (100, 'Woolf', 'Virginia')]"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT NB,NOM,PRENOM FROM MASTER2sub1\n",
    "WHERE NB IN (\n",
    "SELECT NB\n",
    "FROM MASTER2sub1\n",
    "EXCEPT\n",
    "SELECT NB\n",
    "FROM MASTER2sub4\n",
    "NATURAL JOIN MASTER2sub2\n",
    "WHERE MILL =1980)\n",
    "ORDER BY NB\n",
    ";"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.9\n",
    "\n",
    "What clients (buveurs) have bought ONLY wines from 1980?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NB</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>45</td>\n",
       "        <td>Giono</td>\n",
       "        <td>Jean</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>50</td>\n",
       "        <td>Lautreamont</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(44, 'Gide', 'Andre'), (45, 'Giono', 'Jean'), (50, 'Lautreamont', None)]"
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT NB, NOM, PRENOM\n",
    "FROM MASTER2sub1 NATURAL JOIN MASTER2sub4 NATURAL JOIN MASTER2sub2\n",
    "EXCEPT\n",
    "SELECT NB, NOM, PRENOM\n",
    "FROM MASTER2sub1 NATURAL JOIN MASTER2sub4 NATURAL JOIN MASTER2sub2\n",
    "WHERE MILL != 1980"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.10\n",
    "\n",
    "List all wines from 1980"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>CRU</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Arbois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Chateau Corton Grancey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cornas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cote de Brouilly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Cotes de Provence</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Etoile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Fleurie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Mercurey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Meursault</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Rasteau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Saint Amour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Seyssel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Tavel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>Volnay</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Arbois',),\n",
       " ('Chateau Corton Grancey',),\n",
       " ('Cornas',),\n",
       " ('Cote de Brouilly',),\n",
       " ('Cotes de Provence',),\n",
       " ('Etoile',),\n",
       " ('Fleurie',),\n",
       " ('Mercurey',),\n",
       " ('Meursault',),\n",
       " ('Rasteau',),\n",
       " ('Saint Amour',),\n",
       " ('Seyssel',),\n",
       " ('Tavel',),\n",
       " ('Volnay',)]"
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "SELECT  DISTINCT CRU\n",
    "FROM MASTER2sub2\n",
    "NATURAL JOIN MASTER2sub1\n",
    "WHERE MILL = 1980"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.11\n",
    "\n",
    "What are the wines from 1980 bought by NB=2?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NV</th>\n",
       "        <th>CRU</th>\n",
       "        <th>MILL</th>\n",
       "        <th>DEGRE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>Mercurey</td>\n",
       "        <td>1980</td>\n",
       "        <td>11.5</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(1, 'Mercurey', 1980, 11.5)]"
      ]
     },
     "execution_count": 190,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "SELECT NV,CRU,MILL,DEGRE\n",
    "FROM MASTER2sub2\n",
    "NATURAL JOIN MASTER2sub4\n",
    "WHERE MILL = 1980 AND NB=2;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exercise 2.12\n",
    "\n",
    "What clients (buveurs) have bought ALL the wines from 1980?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///wine.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>NB</th>\n",
       "        <th>NOM</th>\n",
       "        <th>PRENOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>44</td>\n",
       "        <td>Gide</td>\n",
       "        <td>Andre</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(44, 'Gide', 'Andre')]"
      ]
     },
     "execution_count": 259,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT NB, NOM, PRENOM\n",
    "FROM(SELECT MAX(count_nv), NB\n",
    "FROM(\n",
    "SELECT COUNT(NV) AS count_nv,NB\n",
    "FROM MASTER1sub1\n",
    "NATURAL JOIN MASTER2sub4\n",
    "NATURAL JOIN MASTER2sub2\n",
    "WHERE MILL = 1980\n",
    "GROUP BY NB))\n",
    "NATURAL JOIN MASTER2sub4\n",
    "NATURAL JOIN MASTER2sub1\n",
    "GROUP BY NB;"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}