I have a historical database spanning 25 years. How can I build a query to give me a count by year, of days when rainfall is greater than 1 inch?
Desired result will be like:
1989 11


1990 3
..... ...
2008 17

Thanks