Question
Assume that you have a table ABC that contains two columns: employee name e_name and the salary sal . Write a SQL statement that lists
Assume that you have a table ABC that contains two columns: employee name e_name and the salary sal.
Write a SQL statement that lists all employees names and gives each a 15% pay increase and display new salary always rounded down to the nearest whole number. Display name, old salary, and new salary.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Data Analysis Using SQL And Excel
Authors: Gordon S Linoff
2nd Edition
111902143X, 9781119021438
