Which events have the number of notes between one and three? List the event id and the property id.
CREATE TABLE Customer_Event_Notes (
    Customer_Event_ID VARCHAR
)

CREATE TABLE Customer_Events (
    Customer_Event_ID VARCHAR,
    property_id VARCHAR,
    customer_event_id VARCHAR
)
SELECT T1.Customer_Event_ID, T1.property_id FROM Customer_Events AS T1 JOIN Customer_Event_Notes AS T2 ON T1.Customer_Event_ID = T2.Customer_Event_ID GROUP BY T1.Customer_Event_ID HAVING COUNT(*) BETWEEN 1 AND 3
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: Which events have the number of notes between one and three? List the event id and the property id. ### Input: CREATE TABLE Customer_Event_Notes (
    Customer_Event_ID VARCHAR
)

CREATE TABLE Customer_Events (
    Customer_Event_ID VARCHAR,
    property_id VARCHAR,
    customer_event_id VARCHAR
) ### Response: SELECT T1.Customer_Event_ID, T1.property_id FROM Customer_Events AS T1 JOIN Customer_Event_Notes AS T2 ON T1.Customer_Event_ID = T2.Customer_Event_ID GROUP BY T1.Customer_Event_ID HAVING COUNT(*) BETWEEN 1 AND 3