Multiply two columns in different tables by most recent date

Hi,

I'm having trouble multiplying two colums in two tables to get the most recent value.

The tables look like this:

The TickRef in both tables are related and is one to many, table2 having many entries. What I want to achieve is to multiply sum of Count in table1 with the value from table2 with the most recent date.

Expected result should be like this:

I can't seem to figure this one. Please help or share a link with solution to a similar problem.

Thanks