This question is for SQL$.$

I apologise, i do not have a test database to upload for this question. What i need help with is for an SQL statement that creates a report of the number of variables put in specific states going back a month from the present date. For example if a database had a list of car models, and each model had a number of states that car could be in$,$ Ex$.($Running$,$ Scheduled$-$Maint, Unscheduled$-$Maint, Scrapped$).$ The statement will need to report the number of times a model is put in a down state within a month. The report will need to be in order of the model that is put in a down state the greatest amount of times to the model that is put in a down state the least amount of times. In this case downs states include Scheduled$-$Maint, Unscheduled$-$Main, Scrapped