雪漠山堂

MySQLSELECT DATE_FORMAT(date, '%Y-%m-%d %H:00:00') AS time, AVG(`year`)AS yearFROM trackWHERE Flag = 0 AND Duration >= 300GROUP BY timeORDER BY time;SQLiteSELECT strftime('%Y-%m-%d %H:00:00', nCreateTime) AS nCreateTime,Round(avg(oAvg),2)F