SQL

Question 5 Use the tables in your schema. 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. 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 TY 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 Question 5 Use the tables in your schema. 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. 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 TY 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