title: How can I combine these two SQL queries into a single query?
body: <p>I am using the Sakila database within MySql 5.6.25. </p>
  
  <p>The first query gives me the films which are providing our "store" with the highest revenue in descending order. I also show the times it has been rented  and it's rental rate:</p>
  
  <pre><code>SELECT f.title, f.rental_rate, count(r.rental_id) AS "Times Rented", count(r.rental_id) * f.rental_rate as Revenue
      from film f 
      INNER JOIN inventory i
         ON f.film_id = i.film_id
      INNER JOIN rental r
          ON r.inventory_id = i.inventory_id
      GROUP BY f.title
      ORDER BY revenue DESC
  </code></pre>
  
  <p>The second query is showing us how many copies of the film we have on hand:</p>
  
  <pre><code>SELECT film.title, count(inventory.film_id)
  from film
  INNER JOIN inventory
  ON film.film_id = inventory.film_id
  group by film.title
  </code></pre>
  
  <p>I understand how both queries are working... independently... but when I try to combine them, they produce unexpected results. Please show me the correct way to combine them without changing the manner in which results are being shown.</p>