CS50_0.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "75ee6bb9-5bfe-42d5-90a0-8841c16c0866",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The sql extension is already loaded. To reload it, use:\n",
      "  %reload_ext sql\n"
     ]
    }
   ],
   "source": [
    "%load_ext sql\n",
    "%sql sqlite:///SQL/src0/longlist.db"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f218d2c6-8816-44b6-988f-50f1e519f549",
   "metadata": {},
   "source": [
    "# Show initt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a128c7e1-dc8f-448f-aa58-89f10336b0dd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///SQL/src0/longlist.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>isbn</th>\n",
       "            <th>title</th>\n",
       "            <th>author</th>\n",
       "            <th>translator</th>\n",
       "            <th>format</th>\n",
       "            <th>pages</th>\n",
       "            <th>publisher</th>\n",
       "            <th>published</th>\n",
       "            <th>year</th>\n",
       "            <th>votes</th>\n",
       "            <th>rating</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>9788439736967</td>\n",
       "            <td>Boulder</td>\n",
       "            <td>Eva Baltasar</td>\n",
       "            <td>Nicole d&#x27;Amonville Alegría</td>\n",
       "            <td>paperback</td>\n",
       "            <td>112</td>\n",
       "            <td>Literatura Random House</td>\n",
       "            <td>2022-08-02</td>\n",
       "            <td>2023</td>\n",
       "            <td>2779</td>\n",
       "            <td>3.77</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>9781628971538</td>\n",
       "            <td>Whale</td>\n",
       "            <td>Cheon Myeong-Kwan</td>\n",
       "            <td>Jae Won Chung</td>\n",
       "            <td>paperback</td>\n",
       "            <td>368</td>\n",
       "            <td>Europa Editions</td>\n",
       "            <td>2023-01-19</td>\n",
       "            <td>2023</td>\n",
       "            <td>175</td>\n",
       "            <td>3.97</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>9781642861181</td>\n",
       "            <td>The Gospel According to the New World</td>\n",
       "            <td>Maryse Condé</td>\n",
       "            <td>Richard Philcox</td>\n",
       "            <td>paperback</td>\n",
       "            <td>184</td>\n",
       "            <td>World Editions</td>\n",
       "            <td>2023-03-07</td>\n",
       "            <td>2023</td>\n",
       "            <td>114</td>\n",
       "            <td>3.05</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>9781529414431</td>\n",
       "            <td>Standing Heavy</td>\n",
       "            <td>Gauz</td>\n",
       "            <td>Frank Wynne</td>\n",
       "            <td>paperback</td>\n",
       "            <td>252</td>\n",
       "            <td>MacLehose Press</td>\n",
       "            <td>2022-05-26</td>\n",
       "            <td>2023</td>\n",
       "            <td>322</td>\n",
       "            <td>3.57</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>9781474623025</td>\n",
       "            <td>Time Shelter</td>\n",
       "            <td>Georgi Gospodinov</td>\n",
       "            <td>Angela Rodel</td>\n",
       "            <td>hardcover</td>\n",
       "            <td>304</td>\n",
       "            <td>W&amp;N</td>\n",
       "            <td>2022-04-21</td>\n",
       "            <td>2023</td>\n",
       "            <td>3142</td>\n",
       "            <td>4.05</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('9788439736967', 'Boulder', 'Eva Baltasar', \"Nicole d'Amonville Alegría\", 'paperback', 112, 'Literatura Random House', '2022-08-02', 2023, 2779, 3.77),\n",
       " ('9781628971538', 'Whale', 'Cheon Myeong-Kwan', 'Jae Won Chung', 'paperback', 368, 'Europa Editions', '2023-01-19', 2023, 175, 3.97),\n",
       " ('9781642861181', 'The Gospel According to the New World', 'Maryse Condé', 'Richard Philcox', 'paperback', 184, 'World Editions', '2023-03-07', 2023, 114, 3.05),\n",
       " ('9781529414431', 'Standing Heavy', 'Gauz', 'Frank Wynne', 'paperback', 252, 'MacLehose Press', '2022-05-26', 2023, 322, 3.57),\n",
       " ('9781474623025', 'Time Shelter', 'Georgi Gospodinov', 'Angela Rodel', 'hardcover', 304, 'W&N', '2022-04-21', 2023, 3142, 4.05)]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT * FROM longlist LIMIT 5"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4a476f95-1227-4cbf-a45e-be0cfba6711a",
   "metadata": {},
   "source": [
    "# Select 'title'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ea330545-9656-470a-aa48-80c96689d563",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///SQL/src0/longlist.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>title</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>Boulder</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Whale</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Boulder',), ('Whale',)]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT \"title\" FROM \"longlist\" limit 2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "65e59276-c84b-452f-8b48-5718b6304f08",
   "metadata": {},
   "source": [
    "#Select \"title\" and author"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d53422eb-ff52-41bd-917d-29a969ca3976",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///SQL/src0/longlist.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>title</th>\n",
       "            <th>author</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>Boulder</td>\n",
       "            <td>Eva Baltasar</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Whale</td>\n",
       "            <td>Cheon Myeong-Kwan</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>The Gospel According to the New World</td>\n",
       "            <td>Maryse Condé</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Standing Heavy</td>\n",
       "            <td>Gauz</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Time Shelter</td>\n",
       "            <td>Georgi Gospodinov</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Boulder', 'Eva Baltasar'),\n",
       " ('Whale', 'Cheon Myeong-Kwan'),\n",
       " ('The Gospel According to the New World', 'Maryse Condé'),\n",
       " ('Standing Heavy', 'Gauz'),\n",
       " ('Time Shelter', 'Georgi Gospodinov')]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT \"title\", \"author\" FROM \"longlist\" LIMIT 5"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2ed350a1-1039-45bd-b196-7249dae1085b",
   "metadata": {},
   "source": [
    "# WHERE year >= 2023"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ab007393-e2bf-41c5-826b-17a7c76ecc4f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///SQL/src0/longlist.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>title</th>\n",
       "            <th>author</th>\n",
       "            <th>year</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>Boulder</td>\n",
       "            <td>Eva Baltasar</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Whale</td>\n",
       "            <td>Cheon Myeong-Kwan</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>The Gospel According to the New World</td>\n",
       "            <td>Maryse Condé</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Standing Heavy</td>\n",
       "            <td>Gauz</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Time Shelter</td>\n",
       "            <td>Georgi Gospodinov</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Is Mother Dead</td>\n",
       "            <td>Vigdis Hjorth</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jimi Hendrix Live in Lviv</td>\n",
       "            <td>Andrey Kurkov</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>The Birthday Party</td>\n",
       "            <td>Laurent Mauvignier</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>While We Were Dreaming</td>\n",
       "            <td>Clemens Meyer</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Pyre</td>\n",
       "            <td>Perumal Murugan</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Still Born</td>\n",
       "            <td>Guadalupe Nettel</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>A System So Magnificent It Is Blinding</td>\n",
       "            <td>Amanda Svensson</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Ninth Building</td>\n",
       "            <td>Zou Jingzhi</td>\n",
       "            <td>2023</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Boulder', 'Eva Baltasar', 2023),\n",
       " ('Whale', 'Cheon Myeong-Kwan', 2023),\n",
       " ('The Gospel According to the New World', 'Maryse Condé', 2023),\n",
       " ('Standing Heavy', 'Gauz', 2023),\n",
       " ('Time Shelter', 'Georgi Gospodinov', 2023),\n",
       " ('Is Mother Dead', 'Vigdis Hjorth', 2023),\n",
       " ('Jimi Hendrix Live in Lviv', 'Andrey Kurkov', 2023),\n",
       " ('The Birthday Party', 'Laurent Mauvignier', 2023),\n",
       " ('While We Were Dreaming', 'Clemens Meyer', 2023),\n",
       " ('Pyre', 'Perumal Murugan', 2023),\n",
       " ('Still Born', 'Guadalupe Nettel', 2023),\n",
       " ('A System So Magnificent It Is Blinding', 'Amanda Svensson', 2023),\n",
       " ('Ninth Building', 'Zou Jingzhi', 2023)]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT \"title\", \"author\", \"year\" FROM \"longlist\" WHERE \"year\" >= 2023"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dc714632-c3dd-4896-8a52-745b5013ee00",
   "metadata": {},
   "source": [
    "# Where a certain Author"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "58349f8c-0400-42f6-8d27-8147c2406e74",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///SQL/src0/longlist.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>author</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>Eva Baltasar</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Cheon Myeong-Kwan</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Maryse Condé</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Gauz</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Georgi Gospodinov</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Vigdis Hjorth</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Andrey Kurkov</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Laurent Mauvignier</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Clemens Meyer</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Perumal Murugan</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Guadalupe Nettel</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Amanda Svensson</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Zou Jingzhi</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Fernanda Melchor</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Mieko Kawakami</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Sang Young Park</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Norman Erikson Pasaribu</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Claudia Piñeiro</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Violaine Huisman</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>David Grossman</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Paulo Scott</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jon Fosse</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jonas Eika</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Geentanjali Shree</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Olga Tokarczuk</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Bora Chung</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Éric Vuillard</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Benajamín Labatut</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Andrzej Tichy</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Judith Schalansky</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>David Diop</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Can Xue</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Maria Stepanova</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Adania Shibli</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jaap Robben</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Mariana Enríquez</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Olga Ravn</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Nana Ekvtimishvili</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Ngũgĩ wa Thiong&#x27;o</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Gabriela Cabezón Cámara</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Marieke Lucas Rijneveld</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Nino Haratischvili</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Shokoofeh Azar</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Yōko Ogawa</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jon Fosse</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Daniel Kehlmann</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Emmanuelle Pagano</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Fernanda Melchor</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Samanta Schweblin</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Enrique Vila-Matas</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Willem Anker</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Michel Houellebecq</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Hwang Sok-yong</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jokha Alharthi</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Olga Tokarczuk</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Hubert Mingarelli</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Mazen Maarouf</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Can Xue</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Samanta Schweblin</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Tommy Wieringa</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Sara Stridsberg</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Marion Poschmann</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Alia Trabucco Zerán</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Juan Gabriel Vásquez</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Annie Ernaux</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Ahmed Saadawi</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Jenny Erpenbeck</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Antonio Muñoz Molina</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Laurent Binet</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Gabriela Ybarra</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Christoph Ransmayr</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Javier Cercas</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Wu Ming-Yi</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Han Kang</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>László Krasznahorkai</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Virginie Despentes</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Ariana Harwicz</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>Olga Tokarczuk</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('Eva Baltasar',),\n",
       " ('Cheon Myeong-Kwan',),\n",
       " ('Maryse Condé',),\n",
       " ('Gauz',),\n",
       " ('Georgi Gospodinov',),\n",
       " ('Vigdis Hjorth',),\n",
       " ('Andrey Kurkov',),\n",
       " ('Laurent Mauvignier',),\n",
       " ('Clemens Meyer',),\n",
       " ('Perumal Murugan',),\n",
       " ('Guadalupe Nettel',),\n",
       " ('Amanda Svensson',),\n",
       " ('Zou Jingzhi',),\n",
       " ('Fernanda Melchor',),\n",
       " ('Mieko Kawakami',),\n",
       " ('Sang Young Park',),\n",
       " ('Norman Erikson Pasaribu',),\n",
       " ('Claudia Piñeiro',),\n",
       " ('Violaine Huisman',),\n",
       " ('David Grossman',),\n",
       " ('Paulo Scott',),\n",
       " ('Jon Fosse',),\n",
       " ('Jonas Eika',),\n",
       " ('Geentanjali Shree',),\n",
       " ('Olga Tokarczuk',),\n",
       " ('Bora Chung',),\n",
       " ('Éric Vuillard',),\n",
       " ('Benajamín Labatut',),\n",
       " ('Andrzej Tichy',),\n",
       " ('Judith Schalansky',),\n",
       " ('David Diop',),\n",
       " ('Can Xue',),\n",
       " ('Maria Stepanova',),\n",
       " ('Adania Shibli',),\n",
       " ('Jaap Robben',),\n",
       " ('Mariana Enríquez',),\n",
       " ('Olga Ravn',),\n",
       " ('Nana Ekvtimishvili',),\n",
       " (\"Ngũgĩ wa Thiong'o\",),\n",
       " ('Gabriela Cabezón Cámara',),\n",
       " ('Marieke Lucas Rijneveld',),\n",
       " ('Nino Haratischvili',),\n",
       " ('Shokoofeh Azar',),\n",
       " ('Yōko Ogawa',),\n",
       " ('Jon Fosse',),\n",
       " ('Daniel Kehlmann',),\n",
       " ('Emmanuelle Pagano',),\n",
       " ('Fernanda Melchor',),\n",
       " ('Samanta Schweblin',),\n",
       " ('Enrique Vila-Matas',),\n",
       " ('Willem Anker',),\n",
       " ('Michel Houellebecq',),\n",
       " ('Hwang Sok-yong',),\n",
       " ('Jokha Alharthi',),\n",
       " ('Olga Tokarczuk',),\n",
       " ('Hubert Mingarelli',),\n",
       " ('Mazen Maarouf',),\n",
       " ('Can Xue',),\n",
       " ('Samanta Schweblin',),\n",
       " ('Tommy Wieringa',),\n",
       " ('Sara Stridsberg',),\n",
       " ('Marion Poschmann',),\n",
       " ('Alia Trabucco Zerán',),\n",
       " ('Juan Gabriel Vásquez',),\n",
       " ('Annie Ernaux',),\n",
       " ('Ahmed Saadawi',),\n",
       " ('Jenny Erpenbeck',),\n",
       " ('Antonio Muñoz Molina',),\n",
       " ('Laurent Binet',),\n",
       " ('Gabriela Ybarra',),\n",
       " ('Christoph Ransmayr',),\n",
       " ('Javier Cercas',),\n",
       " ('Wu Ming-Yi',),\n",
       " ('Han Kang',),\n",
       " ('László Krasznahorkai',),\n",
       " ('Virginie Despentes',),\n",
       " ('Ariana Harwicz',),\n",
       " ('Olga Tokarczuk',)]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT \"author\" FROM \"longlist\" ORDER BY('author') ASC;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f56544b5-f355-4714-9bfd-8675770b3b1c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}