title: Oracle Sql getting the value that appears most times for each different value of another column
body: <p>So lets say that i have this table </p>
  
  <pre><code>language | offer
  chinese  |   1
  chinese  |   1
  english  |   1
  spanish  |   2
  spanish  |   2
  italian  |   2
  french   |   3
  </code></pre>
  
  <p>and I want the languange that appears most times for each different offer,like this</p>
  
  <pre><code>language | offer
  chinese  |   1
  spanish  |   2
  french   |   3
  </code></pre>
  
  <p>How do I do this in oracle sql?</p>