Microsoft Interview Question
Senior Software Development EngineersCountry: United States
Two software development teams had a meeting and the records of events created there are more possible events, these events are,
gather requirements represented by 'G',
Merge requirements represented by 'Y',
redesign requirements represented by 'R',
solve represents by 'S'.
G, Y, R represented as (employee-name)(timesevent-name)
S represented as (employee-name)(timesevent-name)(second-employe-name)
Time is represented in minutes from the start of the meeting, meetings is divided into 2 half 45min each that can be representation of time
The first is reqular time which is represented as a single integer, which is time for ex: 45
Second is additional time, which is represented as (time+extra-time)for ex: 45+2.
Assuming it there are no career break then fromYear of the subsequent experience should be sane as the toYear of the previous one (barring the corner case when somebody leaves a job on 31st December and joins the next job on 1st jan) below is the MySQL query that fetches the reqd result:
Logic is: Sum(toYear) - Sum(fromYear) == max(toYear) - min(fromYear)
- The Artist May 24, 2020Can be implemented in one statement in Java using collectors and C# using linq