Please help in query

1

CREATE TABLE Sales (DayCount int identity(1,1), Sales decimal(18,2), Project varchar(50),ResourceName varchar(50))

INSERT Sales VALUES (120,'SMP1','John')
INSERT Sales VALUES (140,'SMP1','John')
INSERT Sales VALUES (150,'SMP1','Alice')
INSERT Sales VALUES (130,'SMP2','Mark')
INSERT Sales VALUES (140,'SMP2','Mark')
INSERT Sales VALUES (160,'SMP2','Magnus')
INSERT Sales VALUES (180,'SMP3','Jessica')
INSERT Sales VALUES (130,'SMP3','Jessica')
INSERT Sales VALUES (170,'SMP3','Tom')
INSERT Sales VALUES (125,'SMP3','Henry')

select * from Sales

SELECT --a.Sales,
SUM(a.Sales) OVER (ORDER BY a.project) AS SalesSum,a.project,
SUM(a.Sales) OVER(Partition by a.ResourceName ORDER BY a.project) AS SalesResource,
a.ResourceName
FROM Sales a group by Sales, project,ResourceName
ORDER BY a.project
Current Result Set

current%20results%20set
current results set.png819×460 4.84 KB

Expected Result
ProjectName Sales
SMP1 410
Alice 150
John 260
SMP2 840
Magnus 160
Mark 270
......................................
........................................
Please do the needfull

2 
SELECT 
   ISNULL(ResourceName,Project) as ProjectName
  ,SUM(Sales) as sales
FROM Sales
GROUP BY GROUPING SETS
(
  (Project, ResourceName)
  ,(Project)
)
ORDER BY Project, GROUPING(ResourceName) desc

output:

ProjectName sales
SMP1 410.00
Alice 150.00
John 260.00
SMP2 430.00
Magnus 160.00
Mark 270.00

dbfiddle