title: SELECT name using MIN and MAX - mysql
body: <p>So I want to be able to show the most expensive movie to rent and the least expensive movie to rent. Basically I want to show the movie title along with its price. Now I am able to get the highest and lowest rental price with this query:</p>
  
  <pre><code>SELECT MAX(rental_rate) as MaxRate, MIN(rental_rate) as MinRate 
  FROM film;
  </code></pre>
  
  <p>However how do I edit that query above to show the movie titles in relation to their rates?</p>
  
  <p>I have also tried:</p>
  
  <pre><code>SELECT title (SELECT MAX(rental_rate) FROM film as MaxRate),
               (SELECT MIN(rental_rate) FROM film as MinRate)
  FROM film;
  </code></pre>
  
  <p>But that did not work.</p>
  
  <p>Any suggestions?</p>