Database Schema:

branch $($ branch$\_$name, branch$\_$city, assets $)$

customer $($ cust$\_$ID$,$ customer$\_$name, customer$\_$street, customer$\_$city $)$

loan $($ loan$\_$number, branch$\_$name, amount $)$

borrower $($ cust$\_$ID$,$ loan$\_$number $)$

account $($ account$\_$number, branch$\_$name, balance $)$

depositor $($ cust$\_$ID$,$ account$\_$number $)$

Write a query to retrieve a list of branch$\_$names for every branch that has at least one customer living in 'Harrison' that has a deposit account with them. Branch names should not be duplicated.

Your solution must include a subquery and a JOIN.