How to form a MySQL query to display average daily values ​​for the current month?

Question

MySQL

There is a table with sensor data that is added to the table every 30 minutes. What query should be to display the average data for each day of the month?

Answer 1

SELECT DATE(timestamp), AVG(value) ...
  FROM table
 GROUP BY DATE(timestamp)

Answer 2

SELECT