Open1

新規企業の登録数

toketoke

こういうSQLを書くと、直近1ヶ月の企業登録数を割り出せる

SELECT 
    DATE(created_at) AS '日付', 
    COUNT(id) AS '登録会社数'
FROM 
    companies
WHERE 
    created_at >= CURDATE() - INTERVAL 30 DAY
GROUP BY 
    DATE(created_at)
ORDER BY 
    DATE(created_at);