I have a very tricky (for me) select statement that I don't know how to solve.
Using MS SQL server...
2 tables, one with competition results (results) and one with personal data (member).
Have memberid in both tables for my join
I want to get the number of starters between 2 dates in each class whose birth year (taken from the column born (member) e.g. 2012-05-12) and competition style is sled
For example. Number of starters who have a birth year of 2012 between the dates 2025-01-01 to 2025-12-31
I've gotten this far, but I don't know how to filter birth year (only the year) in the select statement.
SELECT r.Klass,
count(r.Sluttid) + count(Case When r.NF = '1' then 1 else null end) as [started]
FROM dbo.results AS r
INNER JOIN dbo.member AS f ON r.memberid = f.memberid
Where r.style = 'sled'
AND r.date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY r.Klass Order By r.Klass