RETO

Filtrar el año 2020 y mes 5

SELECT*
FROM platzi.alumnos
WHERE(EXTRACT(YEAR FROM fecha_incorporacion)) IN (2018, 2019);

/* RETO */
SELECT*
FROM platzi.alumnos
WHERE (DATE_PART('YEAR', fecha_incorporacion)) = 2020
AND (DATE_PART('MONTH', fecha_incorporacion)) = 05;

SELECT*
FROM(
	SELECT*,
		DATE_PART('YEAR', fecha_incorporacion) AS anio_incorporacion,
		DATE_PART('MONTH', fecha_incorporacion) AS mes_incorporacion
	FROM platzi.alumnos
) AS alumnos_con_anio
WHERE anio_incorporacion = 2020 AND mes_incorporacion = 05;