Archive: Need help with 2 Mysql Select Queries

Budget 22$ per month

Posted: 5 years ago

Closed

Description: I need help with 2 MYSQL select queries which should be fairly easy for an experienced database developer.

1. Leads Quality and Conversion Report:
Select source,total leads received in period Date(Date_created) between x and y, total converted (where status='converted'), conversion rate (total converted/total leads*100) records from leads table where Date(Date_created) between x and y group by source

2. Staff Performance Report:
select Leadowner,total leads received in period Date(Date_created) between x and y, total converted (where status='converted'), conversion rate (total converted/total leads*100) records from leads table where Date(Date_created) between x and y group by leadowner

I am struggling with "total leads received in period Date(Date_created) between x and y" part.

Attached is the mysql table dump.
Skills:
database development,mysql,software development