SQL Query/Procedure to join records

I need a highly efficient query(ies) to match records between 3 tables. Im attaching a word document and database schema with full specifications Database preferably should be MSSQL, but due the number of records and processing requirements Im open to recommendations I need also a stress load test so the query is run 5,000 times (or more) simultaneously and peaks 2 or 3 seconds wait time ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform TSQL