CareerCup

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:

select emp.name, exp.start, exp.end from tblemployee emp inner join (select id, min(fromYear) as start, max(toYear) as end, sum(fromYear) as sumFrom, sum(toYear) as sumTo from tblexperience group by id) exp on exp.id = emp.id where exp.sumTo - exp.sumFrom = exp.end - exp.start;

Logic is: Sum(toYear) - Sum(fromYear) == max(toYear) - min(fromYear)
Can be implemented in one statement in Java using collectors and C# using linq

By the way what was the interviewer expecting when he asked design patterns, dependency injection? Was he expecting these in context of full stack development?

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.