title: Listing rows which have the same value in a certain column in postgresql
body: <p>I have two tables, Courses and Faculties. </p>
  
  <ul>
  <li>Courses has columns: ID(primary key), description, level,
  instructor_id(foreign key), and semester.</li>
  <li>Faculties has columns: faculty_id(primary key), name, date_of_birth,
  address, email, and level.</li>
  </ul>
  
  <p>instructor_id in Courses references faculty_id in Faculties.</p>
  
  <p>I'm trying to write a query which lists all the instructors who teach more than one course. As I'm new to SQL in general I'm utterly stumped as to how to go about doing this. There are rows in the Courses table with the same value for instructor_id. Thus far I've already joined the tables like this:</p>
  
  <pre><code>SELECT "Courses".description, "Faculties".name FROM "Courses" INNER JOIN 
  "Faculties" ON "Courses".instructor = "Faculties".faculty_id;
  </code></pre>
  
  <p>But I don't know how to filter out the rows which which duplicate values under Instructor column (in other words filter the classes with the same instructor).</p>