Based on Amazon principles: 1. Share one instance where in you worked beyond your level/work and what was the achievement in terms of metrics? 2. Share one scenario showing leadership skills where you took ownership of some task and how you executed it? SQL questions: 1. userid status Timestamp 1 in 2019-01-01 08:00:00 1 out 2019-01-01 18:00:00 2 in 2019-01-01 09:00:00 2 out 2019-01-01 17:00:00 1 in 2019-01-01 19:00:00 quest: Write a query to give the users in the building between timestamp a & b? 2. Write a query to find the first active timestamp and last inactive timestamp for following? userid status cr_time 1 active 2019-01-01 08:00:00 1 active 2019-01-01 09:00:00 1 inactive 2019-01-01 10:00:00 1 inactive 2019-01-01 11:00:00 2 active 2019-01-01 08:00:00 2 inactive 2019-01-01 12:00:00
