Reference no: EM133265977

1. String function plus CASE statement (SQL).

Create a procedure that includes a CASE statement. The code should extract the current Day of the Week from the system time (i.e. Sunday, Monday, etc). Determine the number of characters the day of the week has (i.e. Monday = 6). The CASE statement should then use this variable (i.e. number of characters) to display the mnemonic name (i.e. 6 should display 'SIX').

2. More practice with functions (SQL)

Create a procedure that calls a function. The function should have an argument value of the same type as the salary attribute from the EMPLOYEES table. The function should count the number of employees earning more than the salary amount being passed in. The function should return this count which is then displayed from the calling procedure.