SQLize Online / PHPize Online  /  SQLtest Online

(select film.title as title, film.rating as rating from rental join customer on rental.customer_id = customer.customer_id join inventory on rental.inventory_id = inventory.inventory_id join film on film.film_id = inventory.film_id where customer.first_name='KATIE' and customer.last_name='ELLIOTT' and film.rating = 'R') union all (select film.title as title, film.rating as rating from rental join customer on rental.customer_id = customer.customer_id join inventory on rental.inventory_id = inventory.inventory_id join film on film.film_id = inventory.film_id where customer.first_name='KATIE' and customer.last_name='ELLIOTT' and NOT film.rating = 'R') order by rating