Prime-Time Gym Regulars

Problem

A fitness club records every workout in the table `gym_visits`, one row per visit, with the `member_id`, the `checkin_time` the member started, the `calories_burned`, and an optional `session_score` from 1 to 5 that the member may leave afterwards (NULL when they skip the rating). Find the *prime-time regulars*, defined by ALL of the following: the member logged at least 3 visits; at least 60% of their visits started during prime time (hours 06, 07, 08 in the morning, or 17, 18, 19 in the evening); the average score over the visits they DID rate is at least 4.0; and they rated at least half of their visits. For each qualifying member return their `member_id` and their average rated score as `mean_score`, rounded to 2 decimals. Order by `mean_score` descending, then by `member_id` descending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns member_id, mean_score.

Starter code (SQL)

SELECT *
FROM gym_visits;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium