SELECT COUNT(ID) as InstallCount, SU.Usage,

            CASE WHEN SU.AppName LIKE 'Microsoft Visio Standard%' THEN 'Visio Standard'
                 WHEN SU.AppName LIKE 'Microsoft Visio Professional%' THEN 'Visio Professional'
                 WHEN SU.AppName LIKE 'Microsoft Visio Premium%' THEN 'Visio Premium'
                 WHEN SU.AppName LIKE 'Microsoft Visio for Enterprise Architects%' THEN 'Visio Enterprise Architects' ELSE 'Visio Standard' END as EditionName, ISNULL(PL.Price, 0) as Price, ISNULL(SUM(total_times_used),0) as TimesUsed,
            ISNULL(SUM(total_min_used),0) as MinutesUsed, SU.StatusDate,
            DATENAME(WEEKDAY, SU.StatusDate) as DayofWeek,
            DATENAME(Month, SU.StatusDate) as MonthofYear,
            DATENAME(Day, SU.StatusDate) as NumberofWeek,
            DATENAME(Year, SU.StatusDate) as Year,
          DATENAME(DAYOFYEAR, SU.StatusDate) as YearDay
FROM [PATCHDW].[dbo].[SoftwareUsageVisio] AS SU with (nolock) INNER JOIN
     [PATCHDW].[dbo].[SoftwareTitlePriceList] AS PL with (nolock) ON SU.AppName = PL.AppName
Group by SU.Usage, SU.AppName, StatusDate, PL.Price
Order by SU.Usage, SU.AppName DESC, YearDay DESC