inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] 평균 일일 대여 요금 구하기

    silver's avatar
    silver
    Nov 12, 2024
    [SQL문제풀기] 평균 일일 대여 요금 구하기
     

    문제

    school.programmers.co.kr
    https://school.programmers.co.kr/learn/courses/30/lessons/151136

    해답

    SELECT ROUND(AVG(DAILY_FEE),0) AS AVERAGE_FEE FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = 'SUV';
     
    Share article

    silver

    RSS·Powered by Inblog