title: SQL: Return with simple SQL statement
body: <pre><code>student_id   course_id   course_name
  ---------------------------------------------
  1            1000        'CS'
  2            1000        'CS'
  1            2000        'CHEM'
  2            3000        'ENG'
  3            1000        'CS'
  4            5000        'Bio'
  </code></pre>
  
  <p>I'm trying to return (student_id, course_id, course_name) that take one course,
  using a simple SQL statement, without Subquery and JOIN.</p>
  
  <p>Result should be:</p>
  
  <pre><code>
  Student_ID Course_ID Course_name
  3          1000      'CS'
  4          5000      'Bio'
  </code></pre>
  
  <p>Thank you in advance! :)</p>