1SELECT 
2    age_group,
3    AVG(app_usage_time_min_day) AS average_app_usage,
4    AVG(screen_on_time_hours_day) AS average_screen_hours,
5    AVG(data_usage_mb_day) AS average_usage_mb,
6    -- Count of Android users in each age group
7    COUNT(CASE WHEN operating_system = 'Android' THEN user_id END) AS android_count,
8    -- Count of iOS users in each age group
9    COUNT(CASE WHEN operating_system = 'iOS' THEN user_id END) AS ios_count
10FROM (
11    SELECT 
12        user_id,
13        operating_system,
14        app_usage_time_min_day,
15        screen_on_time_hours_day,
16        data_usage_mb_day,
17        battery_drain_mah_day,
18        CASE 
19            WHEN age BETWEEN 18 AND 24 THEN '18-24'
20            WHEN age BETWEEN 25 AND 34 THEN '25-34'
21            WHEN age BETWEEN 35 AND 44 THEN '35-44'
22            WHEN age BETWEEN 45 AND 54 THEN '45-54'
23            WHEN age >= 55 THEN '55+'
24            ELSE 'Unknown'
25        END AS age_group
26    FROM @kaggle.valakhorasani_mobile_device_usage_and_user_behavior_dataset.user_behavior_dataset
27) AS subquery
28GROUP BY age_group
29ORDER BY age_group ASC;