programmers

KanuKim97 · KanuKim97 · commit 593eef3ed71b · 2022-11-02T00:18:04.000+09:00
diff --git a/Programmers/level0/나머지 구하기.py b/Programmers/level0/나머지 구하기.py
@@ -0,0 +1,2 @@
+def solution(num1, num2):
+    return num1 % num2
diff --git a/Programmers/level0/중앙값 구하기.py b/Programmers/level0/중앙값 구하기.py
@@ -0,0 +1,3 @@
+def solution(array):
+    array.sort()
+    return array[int(len(array)/2)]
diff --git a/Programmers/level0/짝수는 싫어요.py b/Programmers/level0/짝수는 싫어요.py
@@ -0,0 +1,8 @@
+def solution(n):
+    answer = []
+    
+    for i in range(1, n+1):
+        if(i % 2 == 1):
+            answer.append(i)
+    
+    return answer
diff --git a/Programmers/sql/level1/경기도에 위치한 식품창고 목록 출력하기.sql b/Programmers/sql/level1/경기도에 위치한 식품창고 목록 출력하기.sql
@@ -0,0 +1,3 @@
+SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, COALESCE(FREEZER_YN, 'N') AS FREEZER_YN 
+FROM FOOD_WAREHOUSE
+WHERE ADDRESS LIKE '경기도%'
diff --git a/Programmers/sql/level1/나이 정보가 없는 회원 수 구하기.sql b/Programmers/sql/level1/나이 정보가 없는 회원 수 구하기.sql
@@ -0,0 +1,3 @@
+SELECT COUNT(*) AS USERS
+FROM USER_INFO
+WHERE AGE IS NULL

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, COALESCE(FREEZER_YN, 'N') AS FREEZER_YN`
	`2`	`+FROM FOOD_WAREHOUSE`
	`3`	`+WHERE ADDRESS LIKE '경기도%'`