Your question is Java, SQL, and OOP Basics. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Explain your understanding of Java, SQL joins, and core OOP concepts, and how they show up in your QA work.