Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Calories per Minute

Return each member's calories per minute over all workouts (total calories / total minutes), rounded to 2 decimals, highest first.

Table schema

Workouts(id INT PRIMARY KEY, member VARCHAR(10), workout_date DATE, minutes INT, calories INT)

Sample data

id | member | workout_date | minutes | calories
1 | Ann | 2026-09-01 | 30 | 250
2 | Ann | 2026-09-02 | 45 | 400
3 | Ann | 2026-09-04 | 60 | 500
4 | Bob | 2026-09-01 | 20 | 150
5 | Bob | 2026-09-03 | 25 | 200
6 | Cy | 2026-09-02 | 90 | 700

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.