I have what is on the first table, and I want to create what is on the second table. I am not sure how to go about this. Note that the second table displays the percent contribution of each letter to the total. Thanks!
|Letter||id (count distinct)|
|Letter||Percentage of Total|