title: Not able to display the count in SQL Server
body: <p>I want to show the number of episodes whose title contain the words “on” and “ol”.</p>
  <p>Using CTE from the table :- <a href="https://i.stack.imgur.com/2355n.png" rel="nofollow noreferrer">Table</a></p>
  <p>I tried the following code but it is throwing error:</p>
  <pre><code>select 
      count (select Title from tblEpisode 
             where Title like '%on%' or Title like '%ol%') 
  from tblEpisode
  </code></pre>
  <p>Error:</p>
  <blockquote>
  <p>Msg 156, Level 15, State 1, Line 1<br />
  Incorrect syntax near the keyword 'select'.</p>
  <p>Msg 102, Level 15, State 1, Line 1<br />
  Incorrect syntax near ')'.</p>
  </blockquote>
  <p>What is the problem? Please help!</p>