{"error": "SQL Error: SQLSTATE[42703]: Undefined column: 7 ERROR:  column \"clock_out\" does not exist\nLINE 1: SELECT user_id, SUM(EXTRACT(EPOCH FROM (clock_out - clock_in...\n                                                ^ | Query: SELECT user_id, SUM(EXTRACT(EPOCH FROM (clock_out - clock_in))/3600 - COALESCE(break_minutes, 0)/60.0) AS total_net_hours, COUNT(DISTINCT clocked_at::date) AS total_days_worked, SUM(CASE WHEN (EXTRACT(EPOCH FROM (clock_out - clock_in))/3600 - COALESCE(break_minutes, 0)/60.0) <= 8 THEN (EXTRACT(EPOCH FROM (clock_out - clock_in))/3600 - COALESCE(break_minutes, 0)/60.0) ELSE 8 END) AS total_regular_hours, SUM(CASE WHEN (EXTRACT(EPOCH FROM (clock_out - clock_in))/3600 - COALESCE(break_minutes, 0)/60.0) > 8 THEN (EXTRACT(EPOCH FROM (clock_out - clock_in))/3600 - COALESCE(break_minutes, 0)/60.0) - 8 ELSE 0 END) AS total_overtime_hours FROM time_clocks WHERE isdeleted = ? AND clock_out IS NOT NULL GROUP BY user_id"}