[TIL] 241120

SQL퀘스트 풀이

#Lv5. 예산이 가장 큰 프로젝트는? 

#1
select e.Name ,
	   e.Department ,
	   e.Salary
from employees e 
where e.Salary =
	(select max(Salary)
	 from employees e2 
	 where e2.Department = e.Department)
	 
#2
select e.Name ,
	   p.ProjectName ,
	   p.Budget 
from employees e 
join employeeprojects ep on e.EmployeeID = ep.EmployeeID 
join projects p on p.ProjectID = ep.ProjectID 
where p.Budget >= 10000

 

파이썬 퀘스트

import random

first = ('기철초풍', '멋있는', '재미있는')
second = ('도전적인', '노란색의', '바보같은')
third = ('돌고래', '개발자', '오랑우탄' )

def solution():
    answer = random.choice(first)+' '+random.choice(second)+' '+random.choice(third)

    return answer

print(solution())

 

 

파이썬 백준풀이

#오븐시계

hh, mm = map(int, input().split())
time = int(input())

mm += time

if mm >= 60:
    hh += mm // 60
    mm = mm % 60

if hh >= 24:
    hh = hh % 24

print(hh, mm)

#알람시계

hh,mm = map(int,input().split())

if mm >= 45:
    mm = mm - 45

elif mm < 45:
    if hh > 0:
        hh = hh - 1
        mm = mm + 15

    elif hh == 0:
        hh = 23
        mm = mm + 15

print(hh,mm)