How to show table and total cost together?
<p>I am trying to show a list of costs and have the total at the bottom of my list:</p>

<pre><code>mysql&gt; select   title_name, rental_transaction, renter_lname,renter_fname, rental_cost
    -&gt; from  rentals
    -&gt; where rental_date between '161201' and  '161219'
    -&gt; and  DATEDIFF(date(rental_return_date ), date(rental_date ))  &gt; 7;
+----------------------------+--------------------+--------------+--------------+-------------+
| title_name                 | rental_transaction | renter_lname | renter_fname | rental_cost |
+----------------------------+--------------------+--------------+--------------+-------------+
| WarioWare Touched!         |                 13 | Brennan      | Kathleen     |        2.99 |
| Hot Shots Golf: Open Tee   |                 23 | Grey-Gubler  | Eva          |        3.99 |
| WarioWare Touched!         |                 29 | Smithers     | Kieran       |        2.99 |
| The Urbz: Sims in the City |                 56 | Winters      | Emily        |        4.99 |
| Lumines: Puzzle Fusion     |                 68 | Ryan         | Rebecca      |        3.99 |
| WarioWare Touched!         |                 89 | Byrne        | Ann          |        2.99 |
+----------------------------+--------------------+--------------+--------------+-------------+
6 rows in set (0.00 sec)
</code></pre>

<p>I basically want this table, but I want to show the total cost of the rentals at the bottom of the table and am wondering if this is possible to do?</p>