Practice 3: Solutions
1. Write a query to display the current date. Label the column Date.
SELECT sysdate "Date"
FROM dual;
2. The HR department needs a report to display the employee number, last_name, salary, and
...
Practice 3: Solutions
1. Write a query to display the current date. Label the column Date.
SELECT sysdate "Date"
FROM dual;
2. The HR department needs a report to display the employee number, last_name, salary, and
salary increased by 15.5% (expressed as a whole number) for each employee. Label the
column New Salary. Place your SQL statement in a text file named lab_03_02.sql.
SELECT employee_id, last_name, salary,
ROUND(salary * 1.155, 0) "New Salary"
FROM employees;
3. Run your query in the file lab_03_02.sql.
SELECT employee_id, last_name, salary,
ROUND(salary * 1.155, 0) "New Salary"
FROM employees;
4. Modify your query lab_03_02.sql to add a column that subtracts the old salary from the
new salary. Label the column Increase. Save the contents of the file as
lab_03_04.sql. Run the revised query.
SELECT employee_id, last_name, salary,
ROUND(salary * 1.155, 0) "New Salary",
ROUND(salary * 1.155, 0) - salary "Increase"
FROM employees;
5. Write a query that displays the last name (with the first letter uppercase and all other letters
lowercase) and the length of the last name for all employees whose name starts with the
letters J, A, or M. Give each column an appropriate label. Sort the results by the employees’
last names.
SELECT INITCAP(last_name) "Name",
LENGTH(last_name) "Length"
FROM employees
WHERE last_name LIKE 'J%'
OR last_name LIKE 'M%'
OR last_name LIKE 'A%'
ORDER BY last_name
[Show More]
 Charles Herrick - 100 Q&A About Alcoholism & Drug Addiction-Jones and Bartlett Publishers, Inc.png)
