Challenge: Explore Date and Time Functions

Use the date_time_examples table to answer the following business questions about date and time manipulation:

1. Extract the year from the sample_date column.
2. Add 10 days to the sample_date column.
3. Format the sample_timestamp column to show only the year, month, day, hour, and minute (YYYY-MM-DD HH:MM).

Your query should return these columns:

For step 1:

• id;
• sample_date;
• year_extracted.

For step 2:

• id;
• sample_date;
• date_plus_10_days.

For step 3:

• id;
• sample_timestamp;
• formatted_timestamp.