title: SQL - How to query for multiple WHERE values with AND operator
body: <p>I'm a SQL newbie and have been searching for an answer to this but haven't found it yet. Say I want to query for all students that got a score of 80 from a table named students. How would I go about it? I have tried this so far, but it looks like the IN operator is similar to OR since it is giving me results of everyone that got an 80 on any of the tests.</p>
  
  <pre><code>SELECT * FROM students
  WHERE test_name IN ('Quiz','Midterm','Final')
  AND test_scores='80';
  </code></pre>
  
  <p>Thank you ahead of time for the assistance!</p>
  
  <p>Sample data:    </p>
  
  <pre><code> Test Name |  Student ID   |  Student Name  |  Test Score
   Quiz      |   10          |    Tom         |  80
   Midterm   |   50          |    Sally       |  70
  </code></pre>
  
  <p>The results I would like to get back are all the columns of students who got 80 for all three tests. I apologize for the delay, but I guess I don't have the email notifications working properly. I did warn you I was new. I'm going to try the recommended steps to see how it goes. I'll report back.</p>