Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL exercises on employee Database: List the emp_name and salary is increased by 15% and expressed as no.of Dollars

SQL employee Database: Exercise-4 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

4. From the following table, write a SQL query to list the employees’ name, increased their salary by 15%, and expressed as number of Dollars.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List the emp_name and salary is increased by 15% and expressed as no.of Dollars

Sample Solution:

SELECT emp_name,
       to_char(1.15*salary,'$99,999') AS "Salary"
FROM employees;

Sample Output:

 emp_name |  Salary
----------+----------
 KAYLING  | $  6,900
 BLAZE    | $  3,163
 CLARE    | $  2,933
 JONAS    | $  3,401
 SCARLET  | $  3,565
 FRANK    | $  3,565
 SANDRINE | $  1,035
 ADELYN   | $  1,955
 WADE     | $  1,553
 MADDEN   | $  1,553
 TUCKER   | $  1,840
 ADNRES   | $  1,380
 JULIUS   | $  1,208
 MARKER   | $  1,610
(14 rows)

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the unique designations of the employees. Return job name.
Next: From the following table, write a SQL query to list the employee's name and job name as a format of "Employee & Job".

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3