Amazon Data engineer-I | Phone Screen

It started with brief introduction and experience.
3 sql questions:

  1. Basic left join with two tables
  2. group by
  3. partition
    1 python question
    Find the highest occuring number in the list, in case of tie return both numbers.
    [2,4,3,5,2,6,3] this should return 2 and 3 both

Last behavioral question:
Tell about a time, when you performed a task without informing your manager.

Comments (7)