8000 programers · KanuKim97/Algorithm@7a5ef32 · GitHub
[go: up one dir, main page]
Skip to content 8000

Commit 7a5ef32

Browse files
KanuKim97KanuKim97
committed
programers
1 parent 593eef3 commit 7a5ef32

File tree

6 files changed

+60
-0
lines changed

6 files changed

+60
-0
lines changed

‎Programmers/level0/로그인 성공.py

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
def solution(id_pw, db):
2+
row = -1
3+
4+
for i in range(len(db)):
5+
if id_pw[0] == db[i][0]:
6+
row = i
7+
8+
if row == -1 :
9+
return 'fail'
10+
11+
if id_pw[1] == db[row][1] :
12+
return 'login'
13+
else :
14+
return 'wrong pw'

‎Programmers/level0/분수의 덧셈.py

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
import math
2+
3+
def solution(denum1, num1, denum2, num2):
4+
answer = []
5+
6+
denum_final = denum1 * num2 + denum2 * num1
7+
num_final = num1* num2
8+
9+
if math.gcd(denum_final, num_final) == 1 :
10+
return [denum_final, num_final]
11+
else :
12+
return [denum_final/math.gcd(denum_final, num_final), num_final/math.gcd(denum_final, num_final)]
13+
14+
return answer

‎Programmers/level1/콜라문제.py

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
def solution(a, b, n):
2+
answer = 0
3+
4+
while a <= n :
5+
answer += (n//a)*b
6+
n = (n//a)*b + (n%a)
7+
8+
return answer

‎Programmers/sql/level2/카테고리 별 상품 개수 구하기.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
SELECT LEFT(PRODUCT_CODE, 2) AS CATEGORY, COUNT(*) AS PRODUCT
2+
FROM PRODUCT
3+
GROUP BY CATEGORY
4+
ORDER BY CATEGORY

‎Programmers/sql/level3/조건별로 분류하여 주문상태 출력하기.sql

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,11 @@
1+
SELECT
2+
ORDER_ID,
3+
PRODUCT_ID,
4+
DATE_FORMAT(OUT_DATE, '%Y-%m-%d') AS OUT_DATE,
5+
CASE
6+
WHEN DATE(OUT_DATE) <= '2022-05-01' THEN '출고완료'
7+
WHEN DATE(OUT_DATE) > '2022-05-01' THEN '출고대기'
8+
ELSE '출고미정'
9+
END AS '출고여부'
10+
FROM FOOD_ORDER
11+
ORDER BY ORDER_ID

‎Programmers/sql/level4/취소되지 않은 예약 진료하기.sql

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
SELECT A.APNT_NO, P.PT_NAME, P.PT_NO, A.MCDP_CD, D.DR_NAME, A.APNT_YMD
2+
FROM PATIENT AS P, DOCTOR AS D, APPOINTMENT AS A
3+
WHERE
4+
A.APNT_CNCL_YN = 'N' AND
5+
A.MCDP_CD = 'CS' AND
6+
A.APNT_YMD LIKE '2022-04-13%' AND
7+
A.PT_NO = P.PT_NO AND
8+
A.MDDR_ID = D.DR_ID
9+
ORDER BY A.APNT_YMD

0 commit comments

Comments
 (0)
0