문제
해답
SELECT round(avg(DAILY_FEE)) as AVERAGE_FEE from CAR_RENTAL_COMPANY_CAR where CAR_TYPE ="SUV"
CAR_RENTAL_COMPANY_CAR에서 찾아야함 - from CAR_RENTAL_COMPANY_CAR
CAR_TYPE가 SUV인것 - where CAR_TYPE ="SUV”
대여요금의 평균 하는것 - avg(DAILY_FEE)
평균을 소수점 첫째자리에서 반올림 - round(avg(DAILY_FEE))
![[SQL문제풀기] 1. 평균 일일 대여 요금 구하기](https://image.inblog.dev?url=https%3A%2F%2Fsource.inblog.dev%2Ffeatured_image%2F2024-11-12T09%3A15%3A20.140Z-12200bd5-4319-44dd-b635-d4bf6762fe45&w=2048&q=75)