This question is for SQL$.$

The below SQL code generates a report of all the car models put in the assigned states within the last day.

Could you please help modify the below SQL code to also include the names of the models tied to each state?

SELECT

'UNSCHEDULED$\_$MAINT' AS STATE, COUNT$(*)$ AS Models$\_$Count

FROM

Models List

WHERE

state in 'UNSCHEDULED$\_$MAINT'

AND down$\_$date $$ CURRENT$\_$DATE $-$ INTERVAL $\text{'}1\text{'}$ day

UNION ALL

SELECT

'SCHEDULED$\_$MAINT' AS STATE, COUNT$(*)$ AS Models$\_$Count

FROM

Models List

WHERE

state in 'SCHEDULED$\_$MAINT'

AND down$\_$date $$ CURRENT$\_$DATE $-$ INTERVAL $\text{'}1\text{'}$ day

UNION ALL

SELECT

'Running' AS state,

COUNT$(*)$ AS Models$\_$count

FROM

Models List

WHERE

state $=$ 'Running'

AND down$\_$date $$ CURRENT$\_$DATE $-$ INTERVAL $\text{'}1\text{'}$ day;