title: SQL Query: Find the name of the company that has been assigned the highest number of patents
body: <p><img src="https://i.stack.imgur.com/WTqKu.png" alt="Following is the schema of Database"></p>
  
  <p>Using this query I can find the Company Assignee number for company with most patents but I can't seem to print the company name.</p>
  
  <pre><code>SELECT count(*), patent.assignee
  FROM Patent
  GROUP BY patent.assignee
  HAVING count(*) =
      (SELECT max(count(*))
      FROM Patent
      Group by patent.assignee);
  </code></pre>
  
  <p>COUNT(*) --- ASSIGNEE</p>
  
  <pre><code> 9  19715
   9  27895
  </code></pre>
  
  <p>Nesting above query into </p>
  
  <pre><code>SELECT company.compname
  FROM company
  WHERE ( company.assignee = ( *above query* ) );
  </code></pre>
  
  <p>would give an error "too many values" since there are two companies with most patents but above query takes only one assignee number in the WHERE clause. How do I solve this problem? I need to print name of BOTH companies with assignee number 19715 and 27895. Thank you.</p>