2019-12-25から1日間の記事一覧
UnixTimeStampで表現されているカラムを用いて、日付ごとに集計を行うクエリ。 SELECT DATE_FORMAT(FROM_UNIXTIME(c.confirmed_at),'%Y/%m/%d') AS confirm_date, COUNT(ci.id) AS quantity FROM carts AS o JOIN cart_items AS ci ON ci.cart_id = c.id WHE…
UnixTimeStampで表現されているカラムを用いて、日付ごとに集計を行うクエリ。 SELECT DATE_FORMAT(FROM_UNIXTIME(c.confirmed_at),'%Y/%m/%d') AS confirm_date, COUNT(ci.id) AS quantity FROM carts AS o JOIN cart_items AS ci ON ci.cart_id = c.id WHE…