SQL 걷기반
# 5) 공부하다보니 팀 프로젝트 시간이 왔어요!
news0516
2024. 10. 14. 17:01
17.
SELECT name
FROM team_projects
WHERE aws_cost >= 40000
18.
SELECT *
FROM team_projects
WHERE start_date in (2022)
19.
SELECT *
FROM team_projects
WHERE current_date BETWEEN start_date AND end_date
20.
SELECT *,
DATEDIFF(day, end_date, start_date) as "기간"
from team_projects