returns final and customer demand split by weekday

demandByWeekday.sql

--%of demand by weekday (2015)

SELECT 					DATEPART(dw,SettlementDate) datepart,		
		DateName(dw,SettlementDate) datename

			,SUM(CustomerDemandAggregate)/COUNT(CustomerDemandAggregate) as CdperDay
			,SUM(FinalDemandAggregate)/COUNT(FinalDemandAggregate) as fdperDay

  
FROM [TradingDB].[Report].[FinalDemandAggregate]

WHERE YEAR(SettlementDate) = 2015
  and temperaturesetid = '2'
  AND ProfileClassId =1
 Group by DateName(dw,SettlementDate),	DATEPART(dw,SettlementDate)
 
 ORDER by 	DATEPART(dw,SettlementDate)