<prompt> Tuseme una meza inayoitwa mauzo na safu bidhaa_id, sale_date, na sale_amount. Andika swala la SQL ili kupata mauzo ya wastani ya kila siku kwa kila mwezi katika mwaka wa 2022.  <response>: Heres the SQL query to find the average daily sales for each month in the year 2022:SELECT DATE_TRUNCmonth, sale_date AS month, AVGsale_amount EXTRACTday FROM DATE_TRUNCmonth, sale_date::DATE AS avg_daily_sales FROM sales WHERE EXTRACTyear FROM sale_date 2022 GROUP BY month;This query first extracts the month from the sale_date column using the DATE_TRUNC function. Then, it calculates the average daily sales for each month by dividing the sale_amount by the number of days in each month using the EXTRACT function, and taking the average of those daily amounts. The result is grouped by the month. 