전체 글

from collections import deque def solution(queue1, queue2): queue1 = deque(queue1) queue2 = deque(queue2) queue1_sum = sum(queue1) queue2_sum = sum(queue2) cnt = 0 while queue1 and queue2: if queue1_sum == queue2_sum: break if cnt > (len(queue1) + len(queue2))*2: return -1 if queue1_sum < queue2_sum: tmp = queue2.popleft() queue1.append(tmp) queue1_sum += tmp queue2_sum -= tmp cnt += 1 elif queu..

SELECT FACTORY_ID, FACTORY_NAME, ADDRESS FROM FOOD_FACTORY WHERE ADDRESS LIKE "강원도%" ORDER BY FACTORY_ID LIKE문을 어떻게만 쓰는지 알면 쉬운 문제이다.

SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_OF_BIRTH FROM MEMBER_PROFILE WHERE GENDER = 'W' AND MONTH(DATE_OF_BIRTH) = 3 AND TLNO IS NOT NULL ORDER BY MEMBER_ID ASC MONTH라고 DATE에서 날짜만 리턴해주는 간편한 함수를 쓰니 좋다. LIKE나 IN보다는 훨 나은 듯?