CREATE TABLE Customer_Event_Notes (Customer_Event_ID VARCHAR)
CREATE TABLE Customer_Events (Customer_Event_ID VARCHAR, property_id VARCHAR, customer_event_id VARCHAR)

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(*) <= 3 AND COUNT(*) >= 1