LiftLab interview question

What are joint and and a situational question based on SQL