How do you extract the year from a date column named order_date?

• A. SELECT YEAR(order_date) FROM orders;
• B. SELECT EXTRACT(YEAR FROM order_date) AS order_year FROM orders;
• C. SELECT DATEPART(year, order_date) FROM orders;
• D. EXTRACT(YEAR FROM order_date) AS year FROM orders;

Answer: (B)

Extract the year part of a date using the standard EXTRACT syntax and give the result a clear name. EXTRACT(YEAR FROM order_date) returns the year component from order_date, and aliasing it as order_year makes the output easy to read and reuse in further queries (like grouping or reporting). This approach is portable across many database systems, unlike vendor-specific functions such as YEAR() or DATEPART(year, ...). Using a descriptive alias also helps when the result is used in joins or downstream calculations.