This question is for SQL I am trying to create an SQL query that can pull out the number car models that went down for maintenance on a day andthe number of models fixed on a day. The data needs to be organized by day and goes back a month from the present date.Below is the code I have. "UNSCHEDULED$\_$DOWN" and SCHEDULED$\_$DOWN are the two maintenance states and RELEASED is the fixed state SELECT Model$\_$ID$,$ STATE, UPDATED$\_$DATE, COUNT$(*)$ AS Model$\_$COUNTFROM Car$\_$Model$\_$ListWHERE state in $(\text{'}$UNSCHEDULED$\_$DOWN', 'SCHEDULED$\_$DOWN', 'RELEASED'$)$ AND updated$\_$date $>=$ CURRENT$\_$DATE $-$ INTERVAL $\text{'}30\text{'}$ dayGroup By Model$\_$ID$,$ STATE, UPDATED$\_$DATEorder byUPDATED$\_$DATE DESC; The main problem I am having is that I need to organize the pulled data to transfer it to a bar graph.The bar graphs horizontal axis is for the days and the vertical axis is for the number of cars.There needs to be two bars for each day, one for the number of cars brought down that day and one for the number of cars fixed on that day.I am using Excels chart functionality to create the bar graph. Is there a better SQL statement that can be used to accomplish this?