Query editor
WITH UserDailyActivities AS (SELECTfid,DATE(timestamp) AS activity_day,MIN(timestamp) AS first_activity_time,MAX(timestamp) AS last_activity_timeFROMdune.neynar.dataset_farcaster_castsGROUP BYfid, DATE(timestamp)),DailySessionDurations AS (SELECTactivity_day,fid,-- Assuming a function to calculate the difference in minutes exists-- This needs to be adjusted to DuneSQL's syntax and capabilities(EXTRACT(HOUR FROM last_activity_time) - EXTRACT(HOUR FROM first_activity_time)) * 60+ (EXTRACT(MINUTE FROM last_activity_time) - EXTRACT(MINUTE FROM first_activity_time)) AS session_duration_minutesFROMUserDailyActivities),AverageDailySessionTime AS (SELECTactivity_day,AVG(session_duration_minutes) AS avg_session_time_minutesFROMDailySessionDurationsGROUP BYactivity_day)SELECTactivity_day,avg_session_time_minutesFROMAverageDailySessionTimeORDER BYactivity_day;