SELECT count(pk) as count, DATE_FORMAT(date, '%Y%m%d') as date, (sum(pv) / count(pk) * 24) as pv, (sum(house) / count(house) * 24) as house, (sum(wb) / count(wb) * 24) as wb, (sum(netin) / count(netin) * 24) as netin, (sum(netout) / count(netout) * 24) as netout, (max(heatquantity) - min(heatquantity)) as heat, (max(waterheatquantity) - min(waterheatquantity)) as water, min(temp) as tempmin, max(temp) as tempmax, avg(temp) as tempavg FROM prelogvalues WHERE (date > 20241004) AND (date < 20241005) GROUP BY date;