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 pulls the number of variables put in a specific state from a day ago alway 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 pull out and list the number of models put in the Unscheduled$-$Maint state for that day. It will also need to list the number of models released back to the Running state for that day.