How would you write a SQL query to join two tables and filter results based on specific criteria at Great Hill Solutions?