Problema de estadísticas de tabla de inventario asp

sql = "SELECT sname AS [nombre del dispositivo]"

sql = sql & ",SUM(IIF(zt='nuevo producto',1,0)) AS [nuevo producto]"

sql = sql & ",SUM(IIF(zt='ejecutando',1,0)) AS [ejecutando]"

sql = sql &",SUM(IIF(zt=' a reparar', 1,0)) AS [a reparar]"

sql = sql & ",SUM(IIF(zt='desechado', 1,0)) AS [desechado]"

sql = sql & ",SUM(IIF(zt='D'.1,0)) AS [desconocido]"

sql = sql & " FROM [aa] GRUPO POR [nombre]"

Modificado...