Apple Interview Question
Software Engineer / DevelopersCountry: United States
Interview Type: In-Person
select customer_id
from (select customer_id,sum(expenses) as exp
from table_name
group by customer_id,product_id)
orderby exp
where rownum<=5
select customer_id, sum(expenses) as sum_exp where rownum <= 5 group by customer_id order by sum_exp desc;
select customer_id, sum(expense) as se
- myarycn September 18, 2014from table
group by customer_id
order by se desc
limit 5