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
Which events have the number of notes between one and three? List the event id and the property id.
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
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 value and value
Which events have the number of notes between one and three ? List the event id and the property id .