Save average daily rent (with).MySQL)

Here’s a look at the average daily rental fee (with.MySQL).

I want to solve the coding test problem, find out how to solve it differently from the retrospective of the problem I solved, and get to know.

Let’s get to the problem first.

Problem

In the CAR_RENTAL_COMPANY_CAR table, please write a SQL statement that outputs the average daily rental fee for cars with car type ‘SUV’.

At this time, the average daily rental fee should be rounded up to the first decimal place, and the column name should be AVERAGE_FEE.

The following is a CAR_RENTAL_COMPANY_CAR table that contains information about cars being rented by a car rental company.

The CAR_RENTAL_COMPANY_CAR table is structured as follows, and CAR_ID, CAR_TYPE, DAILY_FEE, and OPTIONS represent the car ID, car type, daily rental fee (KRW), and car option list, respectively.

The types of cars are Sedan, SUV, Vans, Truck, and Limousine. The list of car options is a list of keywords separated by commas (‘,’) (e.g., ‘heated seat,’ ‘smart key,’ and ‘parking sensor,’ and the keywords are ‘parking sensor,’ ‘smart key,’ ‘navigation,’ ‘ventilated seat,’ ‘heated seat,’ ‘rear camera,’ and ‘leather seat.’

Input/output Examples

problem solving

SELECT ROUND(AVG(DAILY_FEE)) AS AVERAGE_FEE
FROM CAR_RENTAL_COMPANY_CAR
GROUP BY CAR_TYPE HAVING CAR_TYPE = 'SUV'

Solution Description

This SQL query calculates and returns the average daily rental fee for a particular type of car.

The query extracts data from the CAR_RENTAL_COMPANY_CAR table, and the main components are as follows.

First, in the SELECT section, the calculated average daily rate is rounded up and outputted under the alias AVERAGE_FEE.

ROUND(AVG(DAILY_FEE)) AS AVERAGE_FEE obtains the average value of the DAILY_FEE column and returns it in integer form by rounding off the decimal point.

The FROM section then specifies the default table on which to run the query.

In this case, the CAR_RENTAL_COMPANY_CAR table is used.

Next, the GROUP BY section groups the data based on the CAR_TYPE column.

Allow the average daily rental fee to be calculated for each type of car.

Finally, the HAVING section selects only groups that meet specific conditions among grouped data.

HAVING CAR_TYPE = ‘SUV’ selects only groups with car type ‘SUV’.

This condition allows you to calculate and return only the average daily fee for an SUV.

Conclusion

This query allows you to look up the average daily rental fee for SUV-type cars.

This will give you insight into the rental fee of the SUV.