SQL QUERY get Average one month of a relative day of the week

Question

I need a query that returns me to the average of a relative month, and a day of the week. For example: I need to know the components relating to the month of February, the day of the week Monday. It is possible to define some expression for the DATA, whereas DATA is of the date type no sql

SELECT AVG(P.Quant) AS Expr1
FROM     P
WHERE  (Pro.Tipo = 'B') AND (V.ID= 1)
AND (DATA =:....")

Answer 1

I don’t have 50 points to comment on, but I could post your table structure?!

SELECT avg(month(valor_do_mes)) as media_mes, avg(day(valor_do_dia)) as media_dia FROM tbl WHERE /*aí você pode converter para data e fazer o where*/ MONTH(campo) and DAY(dia)

In case it doesn’t work, send the structure of your table!

Valeuu!

Answer 2

If you want every Monday of February, regardless of the year, use:

SELECT AVG(P.Quant) AS Expr1
FROM     P
WHERE  (Pro.Tipo = 'B') AND (V.ID= 1)
AND EXTRACT(DOW FROM P.data) = 1
AND EXTRACT(MONTH FROM P.data) = 2;

The EXTRACT function may have another name in the DBMS you are using.