title: SQL Sub-Query - how to find a min value
body: <p>I have created a subquery as follows</p>
  
  <pre><code>select hospital.hospitalcode, name, wardno, annualbudget
  from hospital, ward
  where hospital.hospitalcode = ward.hospitalcode
  </code></pre>
  
  <p>The question I am trying to answer is this: Taking account of all hospital wards, which hospital has the ward with the lowest annual budget?  You should display the hospital code and its name, the ward number and its annual budget. </p>
  
  <p>How would I find a single entry for this question? I realise I need to use MIN but do not know where to use this when using multiple column names</p>