Untitled attachment

Notices where this attachment appears

1. zunda ? nはおまけ :green_dango: (zundan@mastodon.zunda.ninja@mastodon.zunda.ninja)'s status on Friday, 28-Dec-2018 11:20:15 JST zunda ? nはおまけ :green_dango:

   突然ですが弊インスタンスは午前中にコーラとレッドブルを飲み夕方にビールを飲むことがわかりました。健全だw

   > SELECT
   EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10') as hour,
   SUM(CASE WHEN text LIKE '%ビール%' THEN 1 ELSE 0 END) AS beer,
   SUM(CASE WHEN text LIKE '%コーラ%' THEN 1 ELSE 0 END) AS coke,
   SUM(CASE WHEN text LIKE '%レッドブル%'
   OR text LIKE '%RedBull%' THEN 1 ELSE 0 END) AS redbull,
   COUNT(1) as total
   FROM statuses WHERE account_id=1
   GROUP BY EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10');