Programmers_MySQL

[Programmers] MySQL 평균 일일 대여요금 구하기

콩유니 2024. 1. 31. 09:32

SELECT      FLOOR(SUM(DAILY_FEE)/COUNT(*)) AS AVERAGE_FEE
FROM        CAR_RENTAL_COMPANY_CAR
WHERE       CAR_TYPE = 'SUV'