title: what should be the output of this query
body: <p>Display the salesmen id, salesmen name and location of those salesmen who are co-located.</p>
  
  <p>I have used self join to  solve it</p>
  
  <pre><code>select s.sid, s.sname, s.location 
  from salesman s 
  inner join salesman ss on s.location = ss.location 
  where s.location=ss.location
  </code></pre>
  
  <pre><code>Salesman  Table
  
  SID SNAME   LOCATION
  1   Peter   London
  2   Michael Paris
  3   John    Mumbai
  4   Harry   Chicago
  5   Kevin   London
  6   Alex    Chicago
  </code></pre>
  
  <p>Expected output</p>
  
  <pre><code>Expected Result
  SID SNAME   LOCATION
  5   Kevin   London
  6   Alex    Chicago
  1   Peter   London
  4   Harry   Chicago
  </code></pre>