plz use the cluses(SELECT, FROM, WHERE, ODER BY) 1-write a query to display the
ID: 3609918 • Letter: P
Question
plz use the cluses(SELECT, FROM, WHERE, ODER BY)
1-write a query to display the current date.
Label the column date
Date
28-Sep-01
2-for each employee, display the employee number, last_namesalary, increased by 15% and expressed as a whole number.
Label the column new salary.
EMPLOYEE_ID
LAST_NAME
SALARY
NEWSALARY
100
KING
24000
27600
3- Modify your query lab_2. sql to add a column that subtractsthe old salary from the ner salary. Label the column Increases.
EMPLOYEE_ID
LAST_NAME
SALARY
NEWSALARY
Increase
100
king
24000
27600
3600
Date
28-Sep-01
Explanation / Answer
Dear.., 1) Select "date" from tablename 2)for each employee, display the employee number, last_namesalary, increased by 15% and expressed as a whole number.SELECT employee number, last_name, salary, ROUND(salary*1.15) fromemployee
you try for last query .. Still you have any clarification cramsteris there. I Hope this may helps you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.