title: SQL assistance with displaying names who have 2 same letters. Gives error now
body: <p>sorry to ask so many questions about SQL but I am doing exercises that help me revise for my test. </p>
  
  <p>I am trying to display the names of all people who have 2 Ls in their name and are in depno = 30 or their super is "7782". I have written some code for it but its giving an error. I have used the Column name "SUPER" for the manager.</p>
  
  <pre><code>SELECT   ENAME
  FROM     emp
  WHERE    ENAME LIKE 'L%', DEPTNO = 30;
  OR       SUPER = '7782';
  </code></pre>
  
  <p><strong>Thanks alot again!</strong></p>
  
  <p>-Jay</p>
  
  <p>Found the answer:
  The answer should actually be:</p>
  
  <pre><code>SELECT   ENAME 
  FROM     emp 
  WHERE    ENAME LIKE '%L%L%' AND DEPTNO = 30
  OR SUPER = '7782';
  </code></pre>
  
  <p>because the other codes given here give me an error as the end of third line is not supposed to have a semicolon.</p>