please help(:

Hi,

I'm struggling to create a SELECT STATEMENT  that will return YTD values and the % of change per year.

Basically I have a huge Violation table - 'FactParkingViolation' (that holds every Parking Violation for the last 30 years).

I want it to return

The Amount (Count) of the number of Violation per Year between 20015 – 2017 and the % of change

So lets say the fields will be: Count(Year(IssueDate)), Y-2015, Y-2016, Y-2017, %OfChange

Any help will be much appreciated (: