Quote:
Write query to fetch name "paul D ottaway"
Did you see that your example can't use the name "paul D ottaway" to get the desired result as the second line for August is not this name?
The solution is likely to look like OriginalGriff's solution, which use SID.
If your data span on more than a year, you will need to add the
COMPLETED_YEAR
in the
WHERE
clause.