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.

Use the tables in your schema. SQL 1) What is the total

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!