Earnings per Driver

Medium

Now using the same rides table, you want to understand the earnings per driver for a specific month, say July 2021.

Calculate the total number of total earnings per driver in July 2021.

Hint:

You might need to use 2 type of aggregate function to get your results
Earnings per driver is the total earnings divided by the number of drivers

Tables

rides table:

Column Name	Data Format
ride_id	int
driver_id	int
fare	float
uber_cut_percent	float
ride_date

Now using the same rides table, you want to understand the earnings per driver for a specific month, say July 2021.

Calculate the total number of total earnings per driver in July 2021.

Hint:

You might need to use 2 type of aggregate function to get your results
Earnings per driver is the total earnings divided by the number of drivers

Tables

rides table:

Column Name	Data Format
ride_id	int
driver_id	int
fare	float
uber_cut_percent	float
ride_date	date

Example Output:

earnings_per_driver
34.33221...