select *, year(OrderDate) as OrderYear
from Orders