CREATE TABLE party_addresses (party_id NUMBER, address_id NUMBER, date_address_from TIME, address_type_code CLOB, date_address_to TIME)
CREATE TABLE organizations (organization_id NUMBER, date_formed TIME, organization_name CLOB, uk_vat_number CLOB)
CREATE TABLE services (service_id NUMBER, service_type_code CLOB, service_name CLOB, service_descriptio CLOB)
CREATE TABLE parties (party_id NUMBER, payment_method_code CLOB, party_phone CLOB, party_email CLOB)
CREATE TABLE forms (form_id NUMBER, form_type_code CLOB, service_id NUMBER, form_number CLOB, form_name CLOB, form_description CLOB)
CREATE TABLE party_services (booking_id NUMBER, customer_id NUMBER, service_id NUMBER, service_datetime TIME, booking_made_date TIME)
CREATE TABLE addresses (address_id NUMBER, line_1_number_building CLOB, town_city CLOB, zip_postcode CLOB, state_province_county CLOB, country CLOB)
CREATE TABLE party_forms (party_id NUMBER, form_id NUMBER, date_completion_started TIME, form_status_code CLOB, date_fully_completed TIME)
CREATE TABLE individuals (individual_id NUMBER, individual_first_name CLOB, individual_middle_name CLOB, inidividual_phone CLOB, individual_email CLOB, individual_address CLOB, individual_last_name CLOB)
CREATE TABLE organization_contact_individuals (individual_id NUMBER, organization_id NUMBER, date_contact_from TIME, date_contact_to TIME)

What are the names of all cities and states?
SELECT town_city FROM addresses UNION SELECT state_province_county FROM addresses
SELECT "town_city" FROM "addresses" UNION SELECT "state_province_county" FROM "addresses"