TIL - 코드카타

알고리즘

 

def solution(s):
    last_seen = {} 
    answer = []
    
    for i, char in enumerate(s): 
        if char in last_seen:
            answer.append(i - last_seen[char])  
        else:
            answer.append(-1)  
            
        last_seen[char] = i  
    
    return answer

 

 

SQL 

 

SELECT 
    ANIMAL_ID,
    NAME,
    CASE 
        WHEN SEX_UPON_INTAKE LIKE '%Neutered%' OR SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O'
        ELSE 'X'
    END AS NEUTERED
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;