What are the resident details containing the substring 'Miss'?
CREATE TABLE organizations (
    organization_id number,
    parent_organization_id number,
    organization_details text
)

CREATE TABLE timed_locations_of_things (
    thing_id number,
    date_and_time time,
    location_code text
)

CREATE TABLE customer_events (
    customer_event_id number,
    customer_id number,
    date_moved_in time,
    property_id number,
    resident_id number,
    thing_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_details text
)

CREATE TABLE timed_status_of_things (
    thing_id number,
    date_and_date time,
    status_of_thing_code text
)

CREATE TABLE properties (
    property_id number,
    property_type_code text,
    property_address text,
    other_details text
)

CREATE TABLE customer_event_notes (
    customer_event_note_id number,
    customer_event_id number,
    service_type_code text,
    resident_id number,
    property_id number,
    date_moved_in time
)

CREATE TABLE things (
    thing_id number,
    organization_id number,
    type_of_thing_code text,
    service_type_code text,
    service_details text
)

CREATE TABLE residents_services (
    resident_id number,
    service_id number,
    date_moved_in time,
    property_id number,
    date_requested time,
    date_provided time,
    other_details text
)

CREATE TABLE services (
    service_id number,
    organization_id number,
    service_type_code text,
    service_details text
)

CREATE TABLE residents (
    resident_id number,
    property_id number,
    date_moved_in time,
    date_moved_out time,
    other_details text
)
SELECT other_details FROM residents WHERE other_details LIKE '%Miss%'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the resident details containing the substring 'Miss'? ### Input: CREATE TABLE organizations (
    organization_id number,
    parent_organization_id number,
    organization_details text
)

CREATE TABLE timed_locations_of_things (
    thing_id number,
    date_and_time time,
    location_code text
)

CREATE TABLE customer_events (
    customer_event_id number,
    customer_id number,
    date_moved_in time,
    property_id number,
    resident_id number,
    thing_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_details text
)

CREATE TABLE timed_status_of_things (
    thing_id number,
    date_and_date time,
    status_of_thing_code text
)

CREATE TABLE properties (
    property_id number,
    property_type_code text,
    property_address text,
    other_details text
)

CREATE TABLE customer_event_notes (
    customer_event_note_id number,
    customer_event_id number,
    service_type_code text,
    resident_id number,
    property_id number,
    date_moved_in time
)

CREATE TABLE things (
    thing_id number,
    organization_id number,
    type_of_thing_code text,
    service_type_code text,
    service_details text
)

CREATE TABLE residents_services (
    resident_id number,
    service_id number,
    date_moved_in time,
    property_id number,
    date_requested time,
    date_provided time,
    other_details text
)

CREATE TABLE services (
    service_id number,
    organization_id number,
    service_type_code text,
    service_details text
)

CREATE TABLE residents (
    resident_id number,
    property_id number,
    date_moved_in time,
    date_moved_out time,
    other_details text
) ### Response: SELECT other_details FROM residents WHERE other_details LIKE '%Miss%'