Modules

Data Analyst

Data Engineer

Product Data Scientist

AI Engineer

Machine Learning Engineer

Prompt Engineer

Earnings per Driver | Aggregate Functions | Dataford

Earnings per Driver

SQL+1Medium

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

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...