you could use this query:

SELECT State, SUM(State_Customers) AS Total_Customers, COUNT(*) over() FROM Customer_t Group By State Order by State_Customers desc;