select 
		s.stateid,
		s.statename,
		sum(o.paymenttotal) total
from orders o with (nolock)
	inner join transactiontypes tt WITH (NOLOCK)
			on o.transactiontypeid = tt.transactiontypeid
	inner join jurisdictions j WITH (NOLOCK)
			on tt.jurisdictionid = j.jurisdictionid
	inner join states s WITH (NOLOCK)
			on s.stateid = j.stateid
	group by s.statename, s.stateid
	order by total desc

          var  a  = (from o in _context.orders
                        join tt in _context.transactiontypes
                            on o.transactiontypeid equals tt.transactiontypeid
                        join j in _context.jurisdictions
                            on tt.jurisdictionid equals j.jurisdictionid
                        join s in _context.states
                            on j.stateid equals s.stateid
                        group new { o, s } by 
                            new
                            {
                                s.stateid,
                                s.statename
                            }
                            into grouping
                            select new
                            {
                                stateId = grouping.Key.stateid,
                                stateName = grouping.Key.statename,
                                total = grouping.Sum(tot => tot.o.paymenttotal)
                            }).OrderByDescending(t => t.total);

{SELECT 
[Project2].[stateid] AS [stateid], 
[Project2].[statename] AS [statename], 
[Project2].[C1] AS [C1]
FROM ( SELECT 
	[Distinct1].[stateid] AS [stateid], 
	[Distinct1].[statename] AS [statename], 
	(SELECT 
		SUM([Extent5].[paymenttotal]) AS [A1]
		FROM    [dbo].[orders] AS [Extent5]
		INNER JOIN [dbo].[transactiontypes] AS [Extent6] ON [Extent5].[transactiontypeid] = [Extent6].[transactiontypeid]
		INNER JOIN [dbo].[jurisdictions] AS [Extent7] ON [Extent6].[jurisdictionid] = [Extent7].[jurisdictionid]
		INNER JOIN [dbo].[states] AS [Extent8] ON [Extent7].[stateid] = [Extent8].[stateid]
		WHERE ([Distinct1].[stateid] = [Extent8].[stateid]) AND ([Distinct1].[statename] = [Extent8].[statename])) AS [C1]
	FROM ( SELECT DISTINCT 
		[Extent4].[stateid] AS [stateid], 
		[Extent4].[statename] AS [statename]
		FROM    [dbo].[orders] AS [Extent1]
		INNER JOIN [dbo].[transactiontypes] AS [Extent2] ON [Extent1].[transactiontypeid] = [Extent2].[transactiontypeid]
		INNER JOIN [dbo].[jurisdictions] AS [Extent3] ON [Extent2].[jurisdictionid] = [Extent3].[jurisdictionid]
		INNER JOIN [dbo].[states] AS [Extent4] ON [Extent3].[stateid] = [Extent4].[stateid]
	)  AS [Distinct1]
)  AS [Project2]
ORDER BY [Project2].[C1] DESC}