title: Create a VIEW that displays the titles
body: <p>I need to Create a VIEW </p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT Book.BookTitle
  FROM Book, Borrower, Client
  WHERE Book.BookId = Borrower.BookId AND Borrower.ClientId = Client.ClientId AND COUNT(Book.BookId) &gt; 
  (SELECT COUNT(Client.ClientId) FROM Client)*0.2
  GROUP BY Book.BookTitle
  ORDER BY COUNT(Book.BookTitle) DESC;
  </code></pre>
  
  <p>I keep getting this error: 
  Msg 147, Level 15, State 1, Line 547
  An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.</p>
  
  <p>What am I doing wrong?</p>