Question: Use the tables in your schema. SQL 1) What is the total salary of all employees. Format the answer as a dollar amount and label
Use the tables in your schema. SQL
1) What is the total salary of all employees. Format the answer as a dollar amount and label the column as Total Salary
2) For all employees whose last name starts with the letter R (protect against upper/lowercase anomalies using a function), display the employee's last name with the first letter capitalized and all other letters lowercase (be sure to use a function to enforce this), and give the length of their last name. Give the first column a label of "Last Name" and the second "Length". Sort the results in descending order by the employee's last name.

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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
