title: Incorrect syntax near ')' in SQL
body: <p>I am a newbie in SQL and I do not know what is wrong with this code :</p>
  
  <pre><code>select 
      t.title, pub.pub_name 
  from 
      titles t 
  inner join 
      publishers pub on t.title_id = pub.pub_id
  where 
      t.title_id in (select title_id 
                     from
                         (select t.title_id, sum(s.qty) 
                          from titles t 
                          inner join sales s on t.title_id = s.title_id
                          group by t.title_id
                          having sum(s.qty) &gt; 20)
                    )
  </code></pre>
  
  <p>Do you folks know why this is not working?</p>