Day93

알고리즘 코드카타

Consecutive Numbers

SELECT DISTINCT num as ConsecutiveNums 
FROM (
    SELECT num,
           LEAD(num, 1) OVER (ORDER BY id) AS next1,
           LEAD(num, 2) OVER (ORDER BY id) AS next2
    FROM Logs
) AS ConsecutiveLogs
WHERE num = next1 AND num = next2;

예상 대진표

class Solution
{
    public int solution(int n, int a, int b)
    {
        int answer = 0;

        int[] loglist = {};
        if(a<b){
            loglist = new int[]{n, a, b};
        }else{
            loglist = new int[]{n, b, a};
        }

        for(int i = 0; i <= n/2; i++){
            if(loglist[1]%2 == 1 && loglist[1] == loglist[2] - 1){
                answer = i + 1;
                break;
            }
            loglist[0] = loglist[0]/2 + loglist[0]%2;
            loglist[1] = loglist[1]/2 + loglist[1]%2;
            loglist[2] = loglist[2]/2 + loglist[2]%2;
        }

        return answer;
    }
}