SQLize Online / PHPize Online  /  SQLtest Online

SELECT f.title, r.rental_date, r.return_date, p.payment_date, f.rental_rate, IFNULL(TIMESTAMPDIFF(HOUR, r.return_date, p.payment_date) * f.rental_rate, 0) AS lateness_penalty, p.amount FROM rental r JOIN inventory i ON r.inventory_id = i.inventory_id JOIN film f ON i.film_id = f.film_id JOIN payment p ON r.rental_id = p.rental_id JOIN customer c ON r.customer_id = c.customer_id WHERE c.first_name = 'DOROTHY' AND c.last_name = 'TAYLOR' AND MONTH(r.rental_date) = 8 AND YEAR(r.rental_date) = 2005 UNION SELECT 'Total' AS title, NULL AS rental_date, NULL AS return_date, NULL AS payment_date, NULL AS rental_rate, NULL AS lateness_penalty, SUM(p.amount) AS amount FROM rental r JOIN payment p ON r.rental_id = p.rental_id JOIN customer c ON r.customer_id = c.customer_id WHERE c.first_name = 'DOROTHY' AND c.last_name = 'TAYLOR' AND MONTH(r.rental_date) = 8 AND YEAR(r.rental_date) = 2005 ORDER BY rental_date; ; show status like 'Last_query_cost';