Oracle SQL Fundamental 1 - Practice Exercise 2

1. select last_name, salary from employees where salary > 12000
2. select last_name, department_id from employees where employee_id=176
3. select last_name, salary from employees where salary not between 5000 and 12000
4. select last_name,job_id,hire_date from employees where last_name in ('Matos', 'Taylor')
5. select last_name, department_id from employees where department_id in (20,50)
6. select last_name, salary from employees where (salary between 5000 and 12000) AND DEPARTMENT_ID in (20,50)
7. select last_name, hire_date from employees where hire_date >='01-JAN-1994' and hire_date<='31-Dec-1994'
8. select last_name, hire_date from employees where manager_id is null
9. select last_name, salary, COMMISSION_PCT from employees where commission_pct is not null
10. select last_name, salary from employees where salary>&salary_amount
11. select employee_id,last_name,salary,department_id from employees where manager_id =&ID_OF_MANAGER order by &ORDER_BY_COLUMN
12. select last_name from employees where last_name like '__a%'
13. select last_name from employees where last_name like '%a%e%' or last_name like '%e%a%'
14. select last_name,job_id, salary from employees where job_id in ('SA_REP','ST_CLERK')  and 17. salary not in (2500,3500,7000)
15. select last_name, salary, commission_pct, salary * commission_pct "Commission" from employees where commission_pct=.2

Oracle SQL Fundamental 1 - Practice Exercise 1

List of questions and answers to practice exercises given in Oracle Course Material.

Exercise - 1
1. The following SELECT statement executes successfully.
select last_name, job_id, salary as Sal from employees;
Ans: TRUE

2. The following SELECT statement executes successfully.
select * from job_grades;
Ans: TRUE

3. There are 4 coding errors in the following SQL statement can you identify them ?

select employee_id, last_name sal x 12  ANNUAL SALARY from employees
Errors.
1. Comma after last_name
2. Comma after sal x 12
3. Opening double quote before Annual salary
4. Ending double quote after Annual salary.

Questions 4,5,6 cannot be answered, it just has to be understood.

Question 7.
select employee_id , last_name, job_id,hire_date as "Start Date" from employees

Question 9
select distinct job_id from employees;

Q 10
select employee_id "Emp #",last_name Employee,job_id Job, hire_date as "HireDate" from employees

Q11 - Two possible answers I could think.
1. select last_name||' , '||job_id "Employee and Title" from employees

2. select concat(last_name,concat(' , ',job_id)) "Employee and Title" from employees

Question 12
select employee_id||','||first_name||','||last_name||','||email||','||phone_number||','||hire_date||','||job_id||','||salary||','||commission_pct||','||manager_id||','||department_id "The Output" from employees