AmeriHome Mortgage interview question

Write a query using SQL join