We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Top Earners
  5. Discussions

Top Earners

Sort by

recency

|

3519 Discussions

|

  • nazrianwar10
     + 0 comments

    select months*salary AS earnings, count(employee_id) from Employee group by earnings order by earnings desc limit 1;

  • basusharma16
     + 0 comments

    SELECT max(months*salary), count(*) from Employee where (months*salary) = (SELECT max(months*salary) from Employee) ;

  • studiekaz
     + 0 comments

    SELECT months * salary AS earnings, COUNT(*) AS employee_count FROM employee GROUP BY earnings HAVING earnings = ( SELECT MAX(months * salary) FROM employee );

  • perezjonathan130
     + 0 comments
    select  MAX(salary * months) as earning, count(*) from employee where (salary * months) = (select MAX(salary*months)from employee)

  • iamsohail2001
     + 0 comments

    SELECT earning, count(earning) FROM

    (SELECT employee_id, salary, months*salary as earning FROM Employee ORDER BY months*salary DESC) as ren

    Group BY earning ASC ORDER BY count(earning) DESC LIMIT 1;