SELECT DATE(jst, '+9 hours') AS datejst,
       SUM(view_count) AS daily_views
  FROM schedule
 WHERE segment_id IN (1, 2, 3, 4, 5, 6)
   AND view_count IS NOT NULL
 GROUP BY datejst
 ORDER BY jst;