title: List all authors who have published books in all genres
body: <p>List the authorid, authorname and amountpayable for the author who has published books in all genre.</p>
  
  <p><code>Author</code> table:</p>
  
  <pre><code>Authorid Authorname Amountpayable
  </code></pre>
  
  <p><code>Manuscript</code> table</p>
  
  <pre><code>Bookid Authorid Bookname Genre Noofcopies Amount 
  </code></pre>
  
  <p>Here's the query I tried:</p>
  
  <pre><code>select 
      AUTHORID,
      authorname,
      amountpayable 
  from author 
  Where authorid IN having count(distinct "GENRE") = (select count(distinct "GENRE") from manuscript);
  </code></pre>