NEED HELP ASAP!!

Question

1. Use HR Database
2. Write the SQL in Transact SQL

Question: How to write an SQL statement to Return the name of the manager of Finance Department.

Answer 1

I need to know if the 'Manager is in the finance department' designation is part of the person/manager entity or if the department designation is defined in a separate relatable table. If you want precise help, I'll need the database structure. Also, this doesn't need to be inside a Transaction, as it is a select statement that only reads data.