sql 年月周日查询

    SELECT COUNT(1) AS count, DATE_FORMAT(create_time, '%Y-%m-%d') AS date
        FROM m_statistic
        GROUP BY date
        ORDER BY date asc ;

            SELECT COUNT(1) AS count, CONCAT(YEAR(create_time), '-', WEEK(create_time)) AS date
                FROM m_statistic
                GROUP BY date
                ORDER BY date ASC;

        SELECT COUNT(1) AS count, CONCAT(YEAR(create_time), '-', MONTH(create_time)) AS date
            FROM m_statistic
            GROUP BY date
            ORDER BY date ASC;

        SELECT COUNT(1) AS count, YEAR(create_time) AS date
            FROM m_statistic
            GROUP BY date
            ORDER BY date ASC;