CREATE TABLE address (address_id NUMBER, address CLOB, address2 CLOB, district CLOB, city_id NUMBER, postal_code CLOB, phone CLOB, last_update TIME)
CREATE TABLE payment (payment_id NUMBER, customer_id NUMBER, staff_id NUMBER, rental_id NUMBER, amount NUMBER, payment_date TIME, last_update TIME)
CREATE TABLE film_text (film_id NUMBER, title CLOB, description CLOB)
CREATE TABLE language (language_id NUMBER, name CLOB, last_update TIME)
CREATE TABLE inventory (inventory_id NUMBER, film_id NUMBER, store_id NUMBER, last_update TIME)
CREATE TABLE film_actor (actor_id NUMBER, film_id NUMBER, last_update TIME)
CREATE TABLE customer (customer_id NUMBER, store_id NUMBER, first_name CLOB, last_name CLOB, email CLOB, address_id NUMBER, active BOOLEAN, create_date TIME, last_update TIME)
CREATE TABLE actor (actor_id NUMBER, first_name CLOB, last_name CLOB, last_update TIME)
CREATE TABLE city (city_id NUMBER, city CLOB, country_id NUMBER, last_update TIME)
CREATE TABLE category (category_id NUMBER, name CLOB, last_update TIME)
CREATE TABLE rental (rental_id NUMBER, rental_date TIME, inventory_id NUMBER, customer_id NUMBER, return_date TIME, staff_id NUMBER, last_update TIME)
CREATE TABLE store (store_id NUMBER, manager_staff_id NUMBER, address_id NUMBER, last_update TIME)
CREATE TABLE staff (staff_id NUMBER, first_name CLOB, last_name CLOB, address_id NUMBER, picture others, email CLOB, store_id NUMBER, active BOOLEAN, username CLOB, password CLOB, last_update TIME)
CREATE TABLE film (film_id NUMBER, title CLOB, description CLOB, release_year TIME, language_id NUMBER, original_language_id NUMBER, rental_duration NUMBER, rental_rate NUMBER, length NUMBER, replacement_cost NUMBER, rating CLOB, special_features CLOB, last_update TIME)
CREATE TABLE film_category (film_id NUMBER, category_id NUMBER, last_update TIME)
CREATE TABLE country (country_id NUMBER, country CLOB, last_update TIME)

Find all the films longer than 100 minutes, or rated PG, except those who cost more than 200 for replacement. List the titles.
SELECT title FROM film WHERE length > 100 OR rating = 'PG' EXCEPT SELECT title FROM film WHERE replacement_cost > 200
SELECT "title" FROM "film" WHERE "length" > 100 OR "rating" = 'PG' EXCEPT SELECT "title" FROM "film" WHERE "replacement_cost" > 200