sql查看昨天的数据，查看昨天往前7天的数据

-- 查询昨天的数据
        SELECT energy_name,SUM(energy_ton) as  energy_ton,energy_type,del_flag,create_time,update_time
        FROM
            eo_energy
        WHERE
            TO_DAYS( `create_time` ) = TO_DAYS(NOW()) - 1
          AND del_flag = 0
        GROUP BY
            energy_name,energy_type,create_time,update_time

-- 查询昨天往前7天的平均数据
    SELECT energy_name,AVG(energy_ton) AS energy_ton
        FROM eo_energy
        WHERE create_time BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND DATE_SUB(CURDATE(), INTERVAL 0 DAY) AND del_flag = 0
        GROUP BY energy_name