SELECT 
  case
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=1 then 'SUNDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=2 then 'MONDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=3 then 'TUESDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=4 then 'WEDNESDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=5 then 'THURSDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=6 then 'FRIDAY'
  when EXTRACT(DAYOFWEEK FROM date(TIMESTAMP_MICROS(event_timestamp)))=7 then 'SATURDAY'
  else 'other'end as dayofweek,
  FORMAT_DATETIME('%H', datetime(TIMESTAMP_MICROS(event_timestamp))) as hour,
  SUM(IF(event_name = 'use_extra_steps', 1, 0)) as use_extra_steps
FROM `firebase-public-project.analytics_153293282.events_2018*`
GROUP BY dayofweek, hour
ORDER BY dayofweek, hour