Forum Moderators: open
I'm data mining for searches run from my website. Many searches run each day, so I need to get the average for each value for each day in the date range. How would I do this with a single query? Right now I'm messing with:
SELECT AVG(price_low), AVG(price_high), AVG(parts_low), AVG(parts_high), DATE(timestamp) AS date
FROM searches WHERE 1
GROUP BY timestamp
So instead of having 200 rows returned for only 10 dates, I'd like 10 rows, with averages of the values searched within each day.