Interview Question for Software Engineer In Test at Google:

I wasn't expecting SQL questions, since I state in my CV that I know some SQL - but I make it clear that it isn't a "strong skill", and that I haven't used it for some time. As they say, "anything on your CV is fair game" - and they mean it. Be prepared.

I just had this question at an interview for another company and I did not know it. I had to come back home and pour over it until I figured it out.

SELECT Employee.FirstName, Employee.LastName, Employee_1.FirstName AS SupervisorFirst, Employee_1.LastName AS SupervisorLast
FROM Employee INNER JOIN Employee AS Employee_1 ON Employee.ID = Employee_1.Supervisor_ID;