How to calculate average of count per day in mysql?

@wilmer.lemke 

You can calculate the average count per day in MySQL by following these steps:

1. First, you need to have a table that contains the daily counts. Let's assume you have a table named "daily_counts" with two columns: "date" and "count".
2. Next, you can use the following query to calculate the average count per day:

1

SELECT AVG(count) AS average_count FROM daily_counts;

This query will return the average count across all the days in the "daily_counts" table.

If you want to calculate the average count per day for a specific time period, you can modify the query to include a WHERE clause. For example, to calculate the average count per day for the last week, you can use the following query:

1

SELECT AVG(count) AS average_count FROM daily_counts WHERE date >= CURDATE() - INTERVAL 7 DAY;

This query will only consider the counts for the last 7 days in the calculation.

Note: Make sure to replace "daily_counts" with the actual name of your table, and "date" and "count" with the correct column names in your table.