title: Minimum Travel Time
body: <p>Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id.</p>
  
  <p>I have tried this code and there is something missing in my query as I m getting the error.</p>
  
  <p><img src="https://i.stack.imgur.com/WZJyj.jpg" alt="here is the schema for the query"></p>
  
  <pre><code> select sh.schedule_id,sh.source,sh.destination,sh.duration as travel_time
           from schedule sh
           (select min(sh.duration) from schedule)
           order by sh.schedule_id;
  </code></pre>