Counting by referencing multiple tables in a single function.

Hello,   I'm having troubles figuring out the proper process to count the number of trades that are off on a certain date, using the following tables. There is a table for the Personnel, linke...