How would you write a SQL query to join two tables and filter for specific criteria in support of Farmers Insurance Group reporting needs?