SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT title, release_year, rating FROM film INNER JOIN film_actor USING (film_id) LEFT OUTER JOIN actor USING (actor_id) WHERE NOT EXISTS (SELECT actor_id FROM actor WHERE first_name LIKE 'HENRY' AND last_name LIKE 'BERRY') ORDER BY rating

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear