I first take into account that the parent only has their child's best interest at heart and that their anger is most likely not directed personally at me. Next I would work with them to achieve the results they are looking for.
Situation: The interviewer wants you to present a recent challenge and situation in which you found yourself. Task: What did you have to achieve? The interviewer will be looking to see what you were trying to achieve from the situation. Action: What did you do? The interviewer will be looking for information on what you did, why you did it and what the alternatives were. Results: What was the outcome of your actions? What did you achieve through your actions and did you meet your objectives? What did you learn from this experience and have you used this learning since?
The answer depends on the DB schema, but the gist of it is, if you have TableA with columns C1, C2, and C3 and TableB with columns C4, C5, and C6, and you want to make sure that your join returns only the rows where the values in TableA.C3 are equal to the values in TableB.C5, then the join will look like this: SELECT * FROM TableA JOIN TableB ON (TableA.C3 = TableB.C5); That's about as generic as it can be, There are several different kinds of joins and syntaxes, but this is the idea.
Mostly behavior based questions in the in-person interview so not too hard, most technical questions were asked by the hiring manager in the phone interview, but even then no rigorous technical questions.