In this example table, I'd like to create the 3rd column (testNumberTaken) based on the test date and distinct person that has taken the same test x number of times.

I'm fairly new to SQL so any help would be great! Thank you!

[![enter image description here](https://i.stack.imgur.com/b6Nz5.png)](https://i.stack.imgur.com/b6Nz5.png)