For each order show id, ordered_at, and the year (yr) and month (mo) it was placed, using EXTRACT.

Answer

SELECT id, ordered_at, EXTRACT(YEAR FROM ordered_at) AS yr, EXTRACT(MONTH FROM ordered_at) AS mo FROM orders;