20260305 TIL

[Today I Learn]

- SQL codekata

- Python codekata

- 오늘 배운 세션

- 오늘 배운 미니세션

---

[SQL codekata]

- 문제 1.

1. 문제 링크: https://www.hackerrank.com/challenges/weather-observation-station-15/problem

2. 정답 코드

select round(long_w,4) 
from station 
where lat_n < 137.2345
order by lat_n desc 
limit 1

 

- 문제 2.

1. 문제 링크: https://www.hackerrank.com/challenges/weather-observation-station-16/problem

2. 정답 코드

select round(lat_n,4) 
from station 
where lat_n > 38.7780 
order by lat_n 
limit 1;

 

- 문제 3.

1. 문제 링크: https://www.hackerrank.com/challenges/weather-observation-station-17/problem

2. 정답 코드

select round(long_w,4)
from station 
where lat_n > 38.7780 
order by lat_n 
limit 1

 

---

[Python codekata] 

- 문제 1.

1. 문제 링크: https://school.programmers.co.kr/learn/courses/30/lessons/120823

2. 정답 코드

n = int(input())
for i in range(1,n+1):
    print('*'*i)