Use the tables in your schema. 1) Write a query that produces the following for each employee whose last name begins with an R: earns monthly but wants . Use a function to format the salary with a dollar sign, commas, and 2 decimal places. If formatting salaries in this way introduces extra spaces, use a trimming function to get rid of them. (Hint: This will likely require nesting functions - one within the other.) Label the single column produced as "Dream Salaries". Protect against upper/lowercase anomalies in the database using a function.

Use the tables in your schema. 2) Find the average salary for employees in the IT department (the department name will be 'IT'). Label this column as "Avg Sal". Format the result to display in dollars using commas (for thousands) with 2 decimal places. Use the SQL/86 and SQL/92.

HR DEPARTMENTS department_id department_name manager_id location_id LOCATIONS location_id street_address postal_code city state_province country_id JOB_HISTORY employee_id start_date end_date job_id department_id EMPLOYEES employee_id first_name last_name email phone_number hire_date job_id salary commission_pct manager_id department_id COUNTRIES country_id country_name region_id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name