title: T-sql query to select from multiple records according to priority
body: <p>I have a <code>fruits</code> table, with reference to country. I need to query the table and display the query result.</p>
  
  <p><img src="https://i.stack.imgur.com/L2QZA.png" alt="Query result"></p>
  
  <p>If a fruit appears in the table multiple times, i.e. from multiple countries, then only the result from one country should be shown. Further, the record should be selected based on the priority of the country, as follows: Singapore (most prioritized), Malaysia, Indonesia.</p>
  
  <p>How should I query it?</p>
  
  <p>The result should be like this:</p>
  
  <p><img src="https://i.stack.imgur.com/kzWCo.png" alt="Desired query result"></p>