Member Avatar for Micksnothere

Hello,

Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales.

Here is what I have so far (not sure if my inner joins or even the query is totally correct):

select e.employee_no, e.fname, e.lname, count(o.employee_no) as order_count, sum(ol.qty * p.unit_price) as totalsales
from oes2.employee e
inner join oes2.orders o on e.employee_no = o.employee_no
inner join oes2.orderline ol on o.order_no = ol.order_no
inner join oes2.product p on ol.product_no = p.product_no
group by e.employee_no, e.fname, e.lname
order by sum(ol.qty * p.unit_price) desc


So yes. I just need to list the top 25% of the totalsales. How can I do that?

Thanks,

Mick

  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Try this sample SQL.

select * from (select * from aer order by aer_id desc)
where rownum <= (select count(*)/4 from aer)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.