inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] 레스토랑의 일일 평균 매출액 계산하기

    silver's avatar
    silver
    Aug 19, 2025
    [SQL문제풀기] 레스토랑의 일일 평균 매출액 계산하기
    Contents
    문제SQLite

    문제

    solvesql.com
    solvesql.com
    https://solvesql.com/problems/sales-summary/

    SQLite

    내가 작성한 정답

    select round(avg(tb),2) avg_sales from (select day,sum(total_bill) tb from tips group by day);
    Share article

    silver

    RSS·Powered by Inblog