sold_date IS NULL AND (NOW() - purchase_date) < INTERVAL '1 year' OR sold_date IS NOT NULL AND (sold_date - purchase_date) < INTERVAL '1 year' created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), ...