How would you write a SQL query to join two tables and filter results based on specific risk metrics?