Active days

By John Swindells | Comment
| Share: 
Grouped by activity type:
select `type`,100 * COUNT(DISTINCT(DATE_FORMAT(start_date_local, '%Y-%m-%d'))) / DAYOFYEAR(NOW()) from `exercise_activities`
where `athlete_id`=2887
AND YEAR(`start_date_local`) = YEAR( NOW() )
GROUP BY `type`;

Overall percentage:
select 100 * COUNT(DISTINCT(DATE_FORMAT(start_date_local, '%Y-%m-%d'))) / DAYOFYEAR(NOW()) from `exercise_activities`
where `athlete_id`=2887
AND YEAR(`start_date_local`) = YEAR( NOW() );

Share:

Comments

It's quiet in here...Add your comment

Here are some more of your Strava stats