Counting a number of dates in one column below another date in another column

[Ben Eldridge]

Hi all,

I am new to SQL and loving the challenge.

I am writing a script at the moment but am struggling with some of the coding. What I want to do is count a number of dates (task dates) in one column from table A that have dates before the contract end date in table B.

eg
Table A (Task dates)
01/01/01
01/01/01
03/01/01

Table B (contract end date)
02/01/01

Result = 2 in a new column
and a % result in a second new column

Any help on this would be amazing!

Thanks,
Ben