title: SQL query to find the students in one course
body: <p>There are three tables </p>
  
  <p>Students, Courses and Registration</p>
  
  <pre><code>  Students has id, name columns
  
    Courses has also course.id, course.name
  </code></pre>
  
  <p>and there is third table joining the Students and Courses table</p>
  
  <pre><code>Registration : stu_id, course_id 
  </code></pre>
  
  <p>One Student can take one or many courses.</p>
  
  <p>I would like to find the name of Students registered in only one course.</p>