CREATE TABLE timed_locations_of_things (thing_id NUMBER, date_and_time TIME, location_code CLOB)
CREATE TABLE customer_event_notes (customer_event_note_id NUMBER, customer_event_id NUMBER, service_type_code CLOB, resident_id NUMBER, property_id NUMBER, date_moved_in TIME)
CREATE TABLE services (service_id NUMBER, organization_id NUMBER, service_type_code CLOB, service_details CLOB)
CREATE TABLE timed_status_of_things (thing_id NUMBER, date_and_date TIME, status_of_thing_code CLOB)
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 residents (resident_id NUMBER, property_id NUMBER, date_moved_in TIME, date_moved_out TIME, other_details CLOB)
CREATE TABLE organizations (organization_id NUMBER, parent_organization_id NUMBER, organization_details CLOB)
CREATE TABLE customers (customer_id NUMBER, customer_details CLOB)
CREATE TABLE properties (property_id NUMBER, property_type_code CLOB, property_address CLOB, other_details CLOB)
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 CLOB)
CREATE TABLE things (thing_id NUMBER, organization_id NUMBER, type_of_thing_code CLOB, service_type_code CLOB, service_details CLOB)

How many residents does each property have? List property id and resident count.
SELECT T1.property_id, COUNT(*) FROM properties AS T1 JOIN residents AS T2 ON T1.property_id = T2.property_id GROUP BY T1.property_id
SELECT "T1"."property_id", COUNT(*) FROM "properties" "T1" JOIN "residents" "T2" ON "T1"."property_id" = "T2"."property_id" GROUP BY "T1"."property_id"