SELECT name FROMM WHERE AND WHERE?

Question

PostgreSQL

Sorry for the lamer question, I can't get a request of this type:

SELECT name, created_at 
FROM table 
WHERE name=0
AND extract(MONTH FROM created_at) = 02;

and the meaning is such that there is a sample of all names = 0 and created ONLY in the second month.
The example shows ALL names with 0 and created not only in the second month.

Answer 1

What is this number 02?
Check what extract returns:

SELECT 
name, 
created_at,
extract(MONTH FROM created_at) 
FROM table 
WHERE name=0