title: Display any value instead of null?
body: <ul>
  <li><p>Database: Tennis</p></li>
  <li><p>Table: Players</p></li>
  <li><p>Some of the Columns: playerno, first name, last name, leagueno.</p></li>
  <li><p>Task: If the league number is NULL, then give the value 1.</p></li>
  <li><p>Question: Can we do this without coalesce function ? or without any other function ?</p></li>
  <li><p>My code is wrong. I still see a null instead of 1. Besides, there is the unnecessary column due to the case.</p></li>
  </ul>
  
  <p>Code:</p>
  
  <pre><code>use tennis;
  select playerno, name, initials,leagueno,
  case 
  when leagueno = null then 1 
  end
  from players
  where tennis.players.town = 'Stratford'
  order by leagueno desc;
  </code></pre>
  
  <p>Please help me to do it correctly. I have the answer which uses coalesce. But i want to try another method.</p>