create five scenarios using the following SQL syntax, clauses, and keywords.

Each scenario must include a select clause.

include the where clause in at least 2 scenarios.

use at 3 of the following date/time or formatting functions: to_char(), to_date(), DATE(), TIME(), NOW(), SYSDATE()

Feel free to use a dual table if you are returning values that are not contained in the database tables.

Lastly, rename at least one resulting field in your result data set using the AS keyword.