I need to Calculate percentage distribution.
percentage distribution = number of "CHRG_SOLD" for each "CHRG_STATE_CODE" / total number of CHRG_SOLD in the US for the State "CHRG_STATE_CODE"
We are using SQL Server as the DB
I am providing sample data for your reference. Kindly help