title: Schedule of cricket matches sql query
body: <p>I have a table with list of countries as shown below. Every country will play against all countries in the list. I need a query to display the list of opponent countries in format (country1, country2) for all the possible matches without repetitions. e.g. c1 &amp; c2 will play against each other. Display list should not have c2 &amp; c1 (repetition)</p>
  
  <pre><code>CtryName
  ---
  c1
  c2
  c3
  c4
  c5
  </code></pre>
  
  <p>It's an interview question. I have no idea how to get expected results. Please help me by a simple query to display expected results.</p>