Chapter 9

A1: 
select gender, current_position, sum(tool_cost) “Tool Cost” 
from employee, emp_tools 
where payroll_number = fk_payroll_number 
group by rollup (gender, current_position) 
order by 1,2;
A2: 
select last_name||’,‘||first_name name, 
tool_cost + cost “Equipment_cost”, 
rank () over (order by tool_cost+cost asc nulls first) 
from employee, 
(select fk_payroll_number, sum(tool_cost) tool_cost 
from employee, emp_tools 
where payroll_number = fk_payroll_number(+) 
group by fk_payroll_number) t, 
(select fk_payroll_number, sum(cost) cost 
from employee, glasses 
where payroll_number = fk_payroll_number(+) 
group by fk_payroll_number) g 
where payroll_number = t.fk_payroll_number(+) 
  and payroll_number = g.fk_payroll_number(+);
A3: 
 select * from ...

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial