LAB Exercise 1 ICT502 WEEK 1 PDF

Preview

Summary

LAB EXERSICE 1Lab Exercise 1: Retrieving Data Using the SQL SELECT Statement By using HR Schema in Oracle Express Edition, answer the following SQL questions. 1. Select the ID, last name, and salary for all of the employees By modifying the SQL in question 1, add a new column name “New Salary”. All ...

Description

LAB EXERSICE 1 Lab Exercise 1: Retrieving Data Using the SQL SELECT Statement By using HR Schema in Oracle Express Edition, answer the following SQL questions. 1. Select the ID, last name, and salary for all of the employees

2. By modifying the SQL in question 1, add a new column name “New Salary”. All of the employees’ salary are increased 13%.

3. Combine the f separated by space (‘ ‘) for each employee.

e name is

4. “Hunold’s department number is 60” Show the SQL for the output as above for all the employees.

5. Find the yearly salary for each employee. Rename the column to Annual Salary...