CREATE TABLE residents (resident_id DECIMAL, property_id DECIMAL, date_moved_in TIME, date_moved_out TIME, other_details TEXT)
CREATE TABLE organizations (organization_id DECIMAL, parent_organization_id DECIMAL, organization_details TEXT)
CREATE TABLE customers (customer_id DECIMAL, customer_details TEXT)
CREATE TABLE customer_event_notes (customer_event_note_id DECIMAL, customer_event_id DECIMAL, service_type_code TEXT, resident_id DECIMAL, property_id DECIMAL, date_moved_in TIME)
CREATE TABLE things (thing_id DECIMAL, organization_id DECIMAL, type_of_thing_code TEXT, service_type_code TEXT, service_details TEXT)
CREATE TABLE residents_services (resident_id DECIMAL, service_id DECIMAL, date_moved_in TIME, property_id DECIMAL, date_requested TIME, date_provided TIME, other_details TEXT)
CREATE TABLE timed_locations_of_things (thing_id DECIMAL, date_and_time TIME, location_code TEXT)
CREATE TABLE services (service_id DECIMAL, organization_id DECIMAL, service_type_code TEXT, service_details TEXT)
CREATE TABLE properties (property_id DECIMAL, property_type_code TEXT, property_address TEXT, other_details TEXT)
CREATE TABLE timed_status_of_things (thing_id DECIMAL, date_and_date TIME, status_of_thing_code TEXT)
CREATE TABLE customer_events (customer_event_id DECIMAL, customer_id DECIMAL, date_moved_in TIME, property_id DECIMAL, resident_id DECIMAL, thing_id DECIMAL)

What are the distinct move in dates of the residents?
SELECT DISTINCT date_moved_in FROM residents
SELECT DISTINCT "date_moved_in" FROM "residents"