title: How can I get the names of authors of books with the shortest titles from this database?
body: <p>Let's suppose I have a database with the following tables</p>
  <pre><code>authors (author_id TEXT, name TEXT)
  
  books (isbn TEXT, publisher TEXT, title TEXT, publication_year INTEGER)
  
  copies (copy_id INTEGER, isbn TEXT)
  
  authorship (isbn TEXT, author_id INTEGER)
  
  categories (category_id INTEGER, category_name TEXT)
  
  in_category (isbn TEXT, category_id INTEGER)
  </code></pre>
  <p>And I want to get the names of authors of books with the shortest titles. I think I could take isbn numbers of books with the shortest titles, get the author_id and from this get the name.</p>
  <p>I would be glad for any help with this problem.</p>