         AND lag_2_start = 1 AND lag_2_event = 3
     )
 );
-
-DROP TABLE device_action_mapping;
-DROP TABLE device_action;
 
 SELECT RUN_METRIC('android/global_counter_span_view.sql',
   'table_name', 'screen_state',

               EXTRACT_ARG(arg_set_id, 'start') AS start
        FROM raw
        WHERE name = 'suspend_resume'
    ) JOIN device_action USING(action)
)
WHERE start = 1
UNION ALL
-- Traces from before b/70292203 was fixed (approx Nov 2020) do not have the
-- action string so we do some convoluted pattern matching that mostly works.
-- TODO(simonmacm) remove this when enough time has passed (mid 2021?)
SELECT
    ts,
    dur,

)
GROUP BY group_id;

DROP TABLE IF EXISTS suspend_slice_;
CREATE TABLE suspend_slice_ AS
-- Traces from after b/70292203 was fixed have the action string so just look
