알고있니

문제https://solvesql.com/problems/daily-arppu/ https://solvesql.com/problems/daily-arppu/ solvesql.com 코드 -- 매출 날짜, 결제 고객 수, 해당 날짜의 매출액, 결제 고객 1인당 평균 결제 금액 -- FROM / JOIN > WHERE > GROUP BY > HAVING > SELECT > ORDER BY 순으로 실행됨 -- 따라서, alias는 아직 존재하지 않음SELECT DATE(order_purchase_timestamp) as dt ,COUNT(DISTINCT customer_id) as pu, ROUND(SUM(payment_value),2) as revenue_daily ,ROUND(SUM(payment..

문제https://solvesql.com/problems/restaurant-vip/ https://solvesql.com/problems/restaurant-vip/ solvesql.com 아이디어- 서브쿼리 풀이- 파티션 풀이 코드 - 서브 쿼리 풀이 -- 요일별로 가장 높은 금액의 결제 내역 출력 SELECT t.total_bill, t.tip, t.sex, t.smoker, t.day, t.time, t.size FROM tips tJOIN ( SELECT day, max(total_bill) as max_total_bil FROM tips GROUP BY day) as m ON t.day = m.day AND t.total_bill = m.max_total_bil; - RANK() OVE..