media_analytics_start_stop_1.sql

WITH start_stop AS (
   SELECT title,
          user_id,
          play_session,
          play_session_sequence, 
          GENERATE_ARRAY(start_event.start, 
                         stop_event.stop
                        ) AS second_breakdown
     FROM start_event
     JOIN stop_event
          USING (title, 
                 user_id, 
                 length, 
                 play_session,
                 play_session_sequence)
)
SELECT * FROM start_stop