CodeKata

SQL

70번 다시 풀고 팀 활동

WITH review_rank AS(
  SELECT
    m.member_id
    , member_name
    , DENSE_RANK() OVER(ORDER BY COUNT(*) DESC) AS ranking
  FROM
    member_profile m
    JOIN rest_review r
    USING(member_id)
  GROUP BY
    m.member_id
)
SELECT
  member_name
  , review_text
  , DATE_FORMAT(review_date, '%Y-%m-%d') AS review_date
FROM
  rest_review r
  JOIN review_rank k
  USING(member_id)
WHERE
  ranking = 1
ORDER BY
  review_date
  , review_text
;

94. Percentage of Users Attended a Contest

• 작성한 쿼리

SELECT
  contest_id
  , ROUND(COUNT(*)*100/(SELECT COUNT(*) FROM users),2) AS percentage
FROM
  register
GROUP BY
  contest_id
ORDER BY
  percentage DESC
  , contest_id ASC
;

Python

35. 부족한 금액 계산하기

• 작성한 코드

def solution(price, money, count):
    answer = 0
    money_total = 0
    for i in range(1, count+1):
        money_total += price*i
    if money_total > money:
        answer = money_total-money
    else:
        pass
    return answer

팀 프로젝트

• 최종 제출을 위한 코드 병합 진행
• 대표 썸네일용 이미지 생성
  

회고

• 와~ 프로젝트 무사히 끝났다~