오늘 학습한 내용

SQL 코드카타

Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

풀이

SELECT CITY, LENGTH(CITY) AS LEN FROM STATION WHERE LENGTH(CITY) = ( SELECT MIN(LENGTH(CITY)) FROM STATION ) ORDER BY CITY ASC LIMIT 1;

SELECT CITY, LENGTH(CITY) AS LEN FROM STATION WHERE LENGTH(CITY) = ( SELECT MAX(LENGTH(CITY)) FROM STATION ) ORDER BY CITY ASC LIMIT 1;

PYTHON 코드카타

문제 설명
순서쌍이란 두 개의 숫자를 순서를 정하여 짝지어 나타낸 쌍으로 (a, b)로 표기합니다. 자연수 n이 매개변수로 주어질 때 두 숫자의 곱이 n인 자연수 순서쌍의 개수를 return하도록 solution 함수를 완성해주세요.

제한사항
1 ≤ n ≤ 1,000,000

풀이
def solution(n):
    answer = 0
    
    for i in range(1, n + 1):
        if n % i == 0:
            answer += 1
            
    return answer
    
    다른 사람 풀이
    
    def solution(n):
    return len([number for number in range(1, n+1) if n % number == 0])