Function to Break Table into 3 Tables

[#1]

I have a start date table, yyyy-mm-dd. I want to create a function to break it into 3 tables like year, date, month. Any help?

[#2]

I want to then count the count of 2015 count of 2016,also count of individual months