1 2 3 4 5
| SELECT IIf(a.Demand_type='Windows and email account%','Windows and email account creation', IIf(a.Demand_type='Grant access internet standard%','Grant access internet standard', IIf(a.Demand_type='Install PC%', 'InstallPC', IIf(a.Demand_type='Internet Access%', 'Internet Access', IIf(a.Demand_type='Install Fixed Phone%', 'Install Fixed Phone', IIf(a.Demand_type='Install Fixed phone%', 'Install Fixed Phone',IIf(a.Demand_type='Internal transfer%', 'Internal transfer', IIf(a.Demand_type='Transfer outside%', 'Transfer outside', a.Demand_type)))))))) AS Demand_Type, format(Month([Demand_launch_date_valid]) & "/" & Year([Demand_launch_date_valid]),'mm/yyyy') AS [Month], Sum(a.Nb_demand) AS [Demand type / month]
FROM Table_finale AS a
WHERE (((a.[Department])="Customer Services")
GROUP BY IIf(a.Demand_type='Windows and email account%','Windows and email account creation', IIf(a.Demand_type='Grant access internet standard%','Grant access internet standard', IIf(a.Demand_type='Install PC%', 'InstallPC', IIf(a.Demand_type='Internet Access%', 'Internet Access', IIf(a.Demand_type='Install Fixed Phone%', 'Install Fixed Phone', IIf(a.Demand_type='Install Fixed phone%', 'Install Fixed Phone',IIf(a.Demand_type='Internal transfer%', 'Internal transfer', IIf(a.Demand_type='Transfer outside%', 'Transfer outside', a.Demand_type)))))))), format(Month([Demand_launch_date_valid]) & "/" & Year([Demand_launch_date_valid]),'mm/yyyy')
ORDER BY Sum(a.Nb_demand) DESC; |
Partager