Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true
- SELECT earning,cnt from ((SELECT (earning),count(*)as cnt from (SELECT (salary*months) as earning FROM employee as a1) as a2
- GROUP BY earning )) as cool ORDER BY earning DESC limit 1
Add Comment
Please, Sign In to add comment
